Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VB Object Help???
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00120777
Message ID:
00121340
Views:
18
>>I'm not much of a VB programmer, but it looks like your missing the workbooks object in your reference. Try:
>>
>> xl.application.workbooks.open "c:\test.xls" 'valid file name
>>
>>Tip: Whenever I'm having trouble with Office Automation, I go into the Office app and record a macro to do what it is I need to do, then look at the VB Script in the macro.
>
>Ken, just when I think I've got everything under control, I try this and the syntax heads off into never-never land where VFP doesn't follow. Usually a couple of inspired guesses (oxymoron?) will get me back on track, but I sure wish VFP would supply a cheat-sheet for all of the Office commands.
>
>Barbara


Try xl.application.workbooks.open(getf())
John Harvey
Shelbynet.com

"I'm addicted to placebos. I could quit, but it wouldn't matter." Stephen Wright
Previous
Reply
Map
View

Click here to load this message in the networking platform