Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Autoformation in Excel (Individual cells alignment)
Message
 
 
À
23/01/2007 10:04:56
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows 2000 SP4
Network:
Windows 2000 Pro
Database:
Visual FoxPro
Divers
Thread ID:
01185017
Message ID:
01188093
Vues:
24
>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform