Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Change active worksheet
Message
From
04/09/2006 05:43:45
Jeffrey Havelock
Skipton Information Group
Leeds, United Kingdom
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Change active worksheet
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows 2000 SP4
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01150661
Message ID:
01150661
Views:
64
Hi All,

I'm opening an Excel spreadsheet using following code ...

RELEASE ALL LIKE o*
oExcel=CREATEOBJECT("Excel.Application")
oExcel.Visible=.T.
oWorkbook=oExcel.Workbooks.Open("MyFile.xls")

My workbook has 8 worksheets. What syntax do I use to change the ActiveSheet?

Kind Regards

Jeff
Jeff Havelock
Senior Data Developer
jeff.havelock@eurodirect.co.uk
Next
Reply
Map
View

Click here to load this message in the networking platform