Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel commands
Message
From
27/04/2005 12:41:30
 
 
To
27/04/2005 10:46:17
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Title:
Miscellaneous
Thread ID:
01008863
Message ID:
01008911
Views:
20
Hi Carlos.

I need to find a list of excel commands. The goal is to execute those commands from Foxpro using Excel as an object.

You have some great tools in VFP to help you with the discovery process. You can open the Excel object library in the Object Browser to learn about its PEMs. You can also use intelliSense to "play" with the Excel object in the command window like so:
oXl = CREATEOBJECT( [Excel.Application] )
oXl.Visible = .T.
oWB = oXl.Workbooks.Add()
oSheet = oWB.Worksheets( 1 )
oSheet.Name = [MyTestSheet]
and so on...
Previous
Reply
Map
View

Click here to load this message in the networking platform