Leemi
Thu Aug 03 09:28:18 CDT 2006
Hi Stephen:
Good morning.
Thanks for the update. I am glad the article helped. Those are extreamly
useful help files for anyone doing OLE automation.
This posting is provided "AS IS" with no warranties, and confers no rights.
Sincerely,
Microsoft FoxPro Technical Support
Lee Mitchell
*-- VFP9 HAS ARRIVED!! --*
Read about all the new features of VFP9 here:
http://msdn.microsoft.com/vfoxpro/
*--Purchase VFP 9.0 here:
http://www.microsoft.com/PRODUCTS/info/product.aspx?view=22&pcid=54787e64-52
69-4500-8bf2-3f06689f4ab3&type=ovr
Keep an eye on the product lifecycle for Visual FoxPro here:
http://support.microsoft.com/gp/lifeselectindex
- VFP5 Mainstream Support retired June 30th, 2003
- VFP6 Mainstream Support retired Sept. 30th, 2003
>Many thanks Lee - I have found teh info I needed
>Stephen
>"Lee Mitchell" <Leemi@online.microsoft.com> wrote in message
>news:SGDithktGHA.2500@TK2MSFTNGXA01.phx.gbl...
> Hi Stephen:
>
> I am not sure of the exact property you need to reference, by you can get
> this information from the Excel object model. You can get information on
> the object models for all the Office products from this article:
>
> 222101 How to find and use Office object model documentation
>
http://support.microsoft.com/default.aspx?scid=kb;EN-US;222101
>
> I hope this helps.
>
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> Sincerely,
> Microsoft FoxPro Technical Support
> Lee Mitchell
>
> *-- VFP9 HAS ARRIVED!! --*
> Read about all the new features of VFP9 here:
>
http://msdn.microsoft.com/vfoxpro/
>
> *--Purchase VFP 9.0 here:
>
http://www.microsoft.com/PRODUCTS/info/product.aspx?view=22&pcid=54787e64-52
> 69-4500-8bf2-3f06689f4ab3&type=ovr
>
> Keep an eye on the product lifecycle for Visual FoxPro here:
>
http://support.microsoft.com/gp/lifeselectindex
> - VFP5 Mainstream Support retired June 30th, 2003
> - VFP6 Mainstream Support retired Sept. 30th, 2003
>
>>I have finally successfully transferred data from vfp9 into an Excel sheet
>>using
>
>>loEx = createobject('Excel.Application')
>
>>My problem is that the row height is varying depending on the data being
>>placed in the cell. Whilst this may be correct so that allthe data can be
>>seen, the result is rather ugly.
>
>>How do I set all the rows in the sheet to be the 'standard' or default
>>height?
>
>>Many thanks
>
>>Stephen