Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP ole Excel question
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00259234
Message ID:
00261511
Views:
51
>I am very sorry to doubt your expertise! The code works if I use the full file path. I am sorry I didn't try it before posting that last message.
> Could you tell me how I could create table boundries and change the text font from VFP5.0 to excel through ole?
> You have been a great help.
> Thanks alot.

I don't know htis off the top of my head, but I can tell you in a few sentences how to do nearly anything you want with Excel or Word automation...

Start the product in question and record a macro of what you want to do programmatically. Then go into the Macro editor and edit the VBA code for the macro you recorded. You now only have to translate the VBA cod eto VFP code. The main difference is the use of named paramaters as opposed to VFP's positional parameters. But they are easily translated in the VBA editor's Object Browser (Alt-F11 to launch VBA editor, F2 to get the object browser) by looking up the function in the search box, right clicking it, and selecting help. There you will find the syntax and parameter positions needed for the method you want to run. The only other thing to worry about is the values of Excel and Word constants, which are used liberally throughout the code samples and macros. To find the literal values of these constants, just type their names in the object browser, and look down at the bottom at the value. NOw you're done.
Erik Moore
Clientelligence
Previous
Reply
Map
View

Click here to load this message in the networking platform