Liam:

Thanks for the reply. I do use an app subfolder to hold the docs. I was wrapped around the axel w/ regard to deciphering the drive letter from one machine to another and vice versa that i didnt think of stripping off the drive letter + path values returned from GETFILE and just saving (and "IF FILE"ing) the filename alone (relative to the start in folder).

thx


>Hi Chris,
>
>As you know where the data is stored, why not instruct (or force) the users to store the documents in a directory relative to the data directory.
>
>Eg F:\Apps\YourApp\Data, F:\Apps\YourApp\Docs
>
>HTH
>
>Liam
>
>
>
>>An option uses GETFILE to let the user find MSWord documents to use as a means of performing a "mail merge" of sorts. These MSWord document filenames are stored in a VFP table. Example:
>>
>>DocName
>>----------------------------
>>C:\My Documents\WordDoc1.Doc
>>
>>Another option performs an IF FILE() on the DOCNAME field value and then prints the document using WORD. Works fine.
>>
>>But if a user on another workstation attempts to use one of these Word docs that another user stored in the table, the IF FILE() fails because the file exists on another workstation (or server) and is not local.
>>
>>I want to avoid:
>>
>>1) creating the same directory structure on every workstation
>>2) copying the WORD docs to each workstation (and recopying when they make changes or add new docs)
>>
>>I have looked at GETUNCPATH.PRG but am still having trouble figuring out how to deal w/ this problem. I thought that if the first IF FILE() fails, then try IF FILE() while spinning thru the UNCs of all the mapped drive letters but that doesnt sound too appealing. I could find an older version of the same filename on a different PC.
>>
>>Any ideas?