Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Open two file in EXCEL.APPLICATION
Message
 
To
26/03/2003 04:54:39
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00770129
Message ID:
00770172
Views:
14
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.
Previous
Reply
Map
View

Click here to load this message in the networking platform