Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel Tab Surfing
Message
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Excel Tab Surfing
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01051478
Message ID:
01051478
Views:
56
What would be the best way to enum unknown spreadsheet tab names or number and touch each tab?
something like
 oExcel=CREATEOBJECT("Excel.Application")
 With oExcel
         .DisplayAlerts= .F.
         .WorkBooks.Open(XLSFile,0)
         FOR iTabor= 1 TO 100
            .Sheets.iTabor.Select()

         ENDFOR 
Edgar L. Bolton, B.S. B.B.A.
Next
Reply
Map
View

Click here to load this message in the networking platform