Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problem with VFP8.0 to Excel Micro
Message
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00841207
Message ID:
00841227
Vues:
26
It did not work. I still have OLE Error. it load the Excel but the run statement did not work. Any idea why?

Thanks, Tai Fei Pao

>Try to specify full path
lcFullName = sys(5)+sys(2003)+'\iedmsdata.xls'
>tmpsheet = GetObject(lcFullName,'excel.sheet')
>XLApp = tmpsheet.application
>XLApp.RUN(lcFullName + "!SAMProject")
>
>>Please help me to fix those codes so I can convert the application from VFP 6.0 to VFP 8.0.
>>
>>For VFP 8.0 I have to put iedmsdata.xls!SAMProject under the Microsoft Office XLStart folder otherwise I will have OLE Error.
>>
>>The codes that works unter VFP 6.0:
>>
>>tmpsheet = GetObject(sys(5)+sys(2003)+'\iedmsdata.xls','excel.sheet')
>>XLApp = tmpsheet.application
>>XLApp.RUN("iedmsdata.xls!SAMProject")
>>XLApp.Visible = .T.
>>RELEASE XLApp
>>
>>Thanks, Tai Fei Pao
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform