Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem with VFP8.0 to Excel Micro
Message
From
22/10/2003 15:00:46
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00841207
Message ID:
00841227
Views:
25
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform