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:
00121305
Views:
15
>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
Barbara Paltiel, Paltiel Inc.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform