Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Automating Excel, Wordpad, Notebook etc.
Message
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00901660
Message ID:
00901700
Views:
19
>It's one thing to be able to get, say, an Excel w/s up, it's another to be know what the commands are. for example, I can get Excel to start from VFP but how do I know what the commands are to, say, open a particular w/s, move to cell(A,13).
>
>Essentially I need to open up certain Excel w/s or CSV files (in either Excel or a text editor). How do I get a list of valid commands, etc., within those app's, so as to make them do my bidding?
>
>TIA
>
>Terry

When I had to do some Word automation, there were two things that helped me:

1. The OLE Automation book from www.hentzenwerke.com
2. Intellisense

For #2, if you create an instance of Excel by using ox = createobject("Excel.Application"), then you can use ox. to pop up Intellisense.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform