General information
Category:
Coding, syntax & commands
>>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.
That did it.
Thanks
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only