Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
IMPORT FROM XLS fails
Message
From
01/04/2014 12:58:19
 
 
To
01/04/2014 11:08:59
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01597888
Message ID:
01597905
Views:
49
>
lcFile = GETFILE("xls*")
>TRY
>     IMPORT FROM (lcFile) XLS
>CATCH
>    ** catch block assumes you're trying to import XLSX file so it opens it and then saves it as XLS 
>ENDTRY
>
>When I execute the IMPORT command VFP simply exits. No error messages. No CATCH commands. No "Send to Microsoft". No nothing.
>
>I'm sure it has something to do with the spreadsheet and I think it has to do with the spreadsheet having macros in it.
>
>Can somebody please enlighten me about conditions which could cause this kind of behavior?
>

Did you try XL5 or XL8 instead of XLS?

Tamar
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform