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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement