Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Autoformation in Excel (Individual cells alignment)
Message
 
 
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows 2000 SP4
Network:
Windows 2000 Pro
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01185017
Message ID:
01188093
Views:
23
>Sorry, I didn't realise you were experimenting. I assumed the other commands were "understood" and already done, and we were just dealing with the formatting problem.
>
>
>Select csrSSheet                              && The cursor to be converted to a s/s
>EXPORT TO ( lcFilePath) TYPE XL5
>LOCAL	loExcel as Excel.Application
>loExcel = CREATEOBJECT( [Excel.Application])
>With loExcel
>  .Workbooks.Open( lcFilePath)
>  .DisplayAlerts 		= .F.
>EndWith
>Thisform.lmFormatSheet( loExcel, lcFilePath)   && The method code above.
>
Yes, I did exactly that in the meantime and it worked fine with a single cell selection. Don't know why I could not make it to work yesterday.
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform