Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
File Path Too Long? Not Anymore! Check out Long Path Tool | Excel Discussion (Misc queries) | |||
http://CannotDeleteFile.net - Cannot Delete File? Try Long Path ToolFilename is too long? Computer Complaining Your Filename Is Too Long? TheLong Path Tool Can Help While most people can go about their businessblissfully unaware of the Windo | Excel Discussion (Misc queries) | |||
Formula too long - new file path is shorter than old file path - Excel 2003 | Excel Worksheet Functions | |||
How set file open path to filepath of file opened with Explorer ? | Excel Programming | |||
get path - save new file - same sub-directory as existing file | Excel Programming |