accessing a word template in a multi user environment

[Meryl]

I have a command button that opens Word and creates a document populating it with data. That works fine, however the document template exists on one computer on drive C. When a user not on that computer tries to use this command button, it won't work because the mapped drive is not the "C" drive. How can I program this so that each user can access the template using the correctly mapped drive?

 

[news.east.earthlink.net]

In your code replace the "C:\" at the beginning of the path with the UNC
(the computer name) - like this: if the computer where the template is
stored name is "Desktop", then in code replace the c:\ with desktop\\
THT

I have a command button that opens Word and creates a document populating

it with data. That works fine, however the document template exists on one
computer on drive C. When a user not on that computer tries to use this
command button, it won't work because the mapped drive is not the "C" drive.
How can I program this so that each user can access the template using the
correctly mapped drive?

 

[Graham R Seach]

Meryl,

The best way is to put the template on the server. Failing that, you could
use the VBA Setting and GetSetting functions to store/save the path to the
template on each machine

Graham R Seach
Microsoft Access MCP, MVP
Sydney, Australia

I have a command button that opens Word and creates a document populating

it with data. That works fine, however the document template exists on one
computer on drive C. When a user not on that computer tries to use this
command button, it won't work because the mapped drive is not the "C" drive.
How can I program this so that each user can access the template using the
correctly mapped drive?