Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Open two file in EXCEL.APPLICATION
Message
 
À
26/03/2003 04:54:39
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00770129
Message ID:
00770172
Vues:
16
Something like this:
filename="hello.xls"
...
ObjExcel.Workbooks.Open(fillpath(filename))
ObjExcel.Workbooks(filename).Activate
or
ObjExcel.Workbooks(2).Activate
....



>Hi,
>
>i use below command to open a EXCEL file and entries in it.
>
>*****
>
>EXCEL_FILE = CREATEOBJECT("EXCEL.APPLICATION")
>EXCEL_FILE.VISIBLE = .F.
>EXCEL_FILE.APPLICATION.WORKBOOKS.OPEN( (MFILE) )
>WITH EXCEL_FILE.ACTIVEWORKBOOK.ACTIVESHEET
>.CELLS(1,1).VALUE = "'" + S_COMP
>ENDWITH
>
>*****
>
>
>now i want to know more command about :-
>
>1. Can i open another EXECL file at same time.
>
>2. How can i switch (SELE) between two file.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform