Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Automating Excel, Wordpad, Notebook etc.
Message
From
06/05/2004 21:08:42
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00901660
Message ID:
00901797
Views:
15
>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

For Excel:

As others have said, macro recording. Macros may need some translation. I have outlined the basic steps in my article, http://www.utmag.com/September2002/Page45.asp.

AFAIK, neither WordPad nor NoteBook can be automated.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform