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
:D

--
ChrisMattoc
-----------------------------------------------------------------------
ChrisMattock's Profile: http://www.excelforum.com/member.php...fo&userid=3391
View this thread: http://www.excelforum.com/showthread.php?threadid=54155