Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to move the range down in excel ?
Message
De
02/12/2008 01:10:14
Yim Ming Sun Derek
Spacious Design Consultant
Hong Kong, Hong Kong
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
How to move the range down in excel ?
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01365010
Message ID:
01365010
Vues:
80
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)
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform