accessing a word template in a multi user environment

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
Meryl said:
I have a command button that opens Word and creates a document populating
Click to expand...
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?
 
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


Meryl said:
I have a command button that opens Word and creates a document populating
Click to expand...
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?
 
Back
Top