>
>You must enclose l0ong file names in quotes as in;
>>
>>>>tempImage = getpict()
>>IF !EMPTY(TempImage)
>> APPEND GENERAL arclient.logo FROM <strong>"&tempimage"</strong> LINK
>>ENDIF
>>
>
>In researching how to use file names with embedded blanks, I came across this method (Thanks!). Now I'd like to know how to do the same thing if the Filename of interest is contained in the field of a table in a different work area.
>
>Suppose fname is a memo field in table fnames containing a very long file name (with embedded blanks). The following generates a 'file does not exist' diagnostic.
>
>SELECT 0
>IMPORT FROM "&fnames.fname" XLS
>
>Apparently the '.' screws up the trick. If I do an intermediate step, it works fine:
>
>SELECT 0
>cfname = fnames.fname
>IMPORT FROM "&cfname" XLS
>
>Any way to acheive the results of the "&varname" trick for complex variable refs without using the intermediate step?
Nope. Not unless this works:
SELECT fnames
IMPORT FROM "&fname" XLS