Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Trying to open an Excel file
Message
From
05/07/2006 16:02:16
 
 
To
05/07/2006 15:55:37
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Environment versions
Visual FoxPro:
VFP 7 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01133971
Message ID:
01133974
Views:
11
This message has been marked as the solution to the initial question of the thread.
lcXlsFile = GETFILE('xls')
IF !EMPTY(lcXLsFile)
   oExcel = CREATEOBJECT("excel.application")
   oExcel.Visible = .T.
   oExWorkbook = oExcel.Workbooks.Open(lcXlsFile)
   *etc
>Hello,
>
>I'm trying to open an Excel file in code, using the following...
>
> oleApp.Workbooks.Open.FILENAME:=(&xlsfile)
>
>(where xlsfile=the filename from GETFILE())
>
>Although it allows me to save and compile, it won't get past this line (Syntax Error).
>
>Any suggestions?
>
>Thanks,
>Martha
.·*´¨)
.·`TCH
(..·*

010000110101001101101000011000010111001001110000010011110111001001000010011101010111001101110100
"When the debate is lost, slander becomes the tool of the loser." - Socrates
Vita contingit, Vive cum eo. (Life Happens, Live With it.)
"Life is not measured by the number of breaths we take, but by the moments that take our breath away." -- author unknown
"De omnibus dubitandum"
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform