Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to move the range down in excel ?
Message
From
02/12/2008 01:10:14
Yim Ming Sun Derek
Spacious Design Consultant
Hong Kong, Hong Kong
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
How to move the range down in excel ?
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01365010
Message ID:
01365010
Views:
77
Hi,
After I export the file to a excel file, I want to open a excel worksheet and move a range of
row down 1 row, but it doesn't work.
Please see my coding.

Please advise.
Derek
 oExcel = CREATEOBJECT([Excel.Application])
 oWorkbook = oExcel.Workbooks.open("C:\CLIENT.XLS")
 oExcel.Visible = .t.	
 oRange = oExcel.activesheet.Range("A1:M17")	
 oRange = oRange.offset(1,0)
Next
Reply
Map
View

Click here to load this message in the networking platform