Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to move the range down in excel ?
Message
 
 
À
02/12/2008 01:10:14
Yim Ming Sun Derek
Spacious Design Consultant
Hong Kong, Hong Kong
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
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:
01365012
Vues:
16
>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)
>
See also Re: Excel Automation Question: Insert a row Thread #1213304
If it's not broken, fix it until it is.


My Blog
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform