File path...

[ChrisMattock]

Me again!

Just attempted to roll out my spreadsheet/word template to som
colleagues and have a problem with the path that the word template i
being loaded up from and the path wheer the file is saved.

Dim appWD As Word.Application
Set appWD = CreateObject("word.application.8")
appWD.Visible = True
appWD.Documents.Open FileName:="H:\LOA Stuff\TEST\LOA_Template.doc"

The path I want to save it to works fine on my computer and i
accessible from others however the drive letters differ machine t
machine.. any way ruond this? I tried omitting the path....

LOA_Template.doc

And having the template in the same directory as the excel file callin
it, but this didn't seem to work. (See my other posts for the full cod

 

[Guest]

You could save it hre:

application.options.DefaultFilePath(wdUserTemplatesPath)

i.e each user will have to save your file at the location indicated by the
above expression; run it in the Immediate Window

?application.options.DefaultFilePath(wdUserTemplatesPath)

 

[aidan.heritage]

use the PROPER location of the file (technically the UNC path) get if H
is PROD on SERVER then type

\\server\prod\loa stuff\etc

as the file path - this way, it will EVEN work if the path isn't mapped
to a drive!