Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Long File Names
Message
From
07/07/1999 10:25:32
Mark Hall
Independent Developer & Voip Specialist
Keston, Kent, United Kingdom
 
 
To
07/07/1999 10:21:10
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00238269
Message ID:
00238273
Views:
13
>I am trying to append from an excel spreadsheet and am having problems with the long file names in windows. Below is the code. Let me know if any of you have run across this problem.
>
>Thanks
>
>xlsfile = GETFILE("xls", "Import File","Import")
>.
>.
>append from &xlsfile type xls
>
>This gives me an error "Command contains unrecognized phrase/keyword." because of the spaces in the macro substitution
>
>also tried
>
>Append from ? type xls
>
>but if the user clicks cancel an error occurs, although this allows the long file names.


Try this,

append from "&xlsfile" type xls

I tested it with a MODI COMM, but it may work.
Regards
Mark

Microsoft VFP MCP
Menulib - OO Menus for VFP www.hidb.com/menulib
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform