>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
Don't use macro substitution - it'll bite you in the butt much of the time with LFNs. You can use name resolution like:
APPEND FROM (xlsfile) TYPE XLS
and avoid the problem entirely.
>
>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.