open xls macro
Assume you want to use a UNC path to get to the file and you know what the
UNC path is.
Dim sName as String
sName = Thisworkbook.worksheets(1).Range("A12").Value
if instr(sName,".xls") = 0 then
sName = sName & ".xls"
End if
sPath = "\\LOGFS03\OGILVTW\Docs"
workbooks.Open sPath & "\" & sName
--
Regards,
Tom Ogilvy
"PaulW" wrote in message
...
Hello Gurus and newsgroup users.
Your assistance please.
I am trying to create a macro that will open a .xls at
specific location on the server.
I have part of the file name within a cell on a separate
spreadsheet.
I.e. cell A12 value equals QQ3E. The file I wish to open
is called QQ3E.xls.
Any help you can provide would be appreciated.
My apologise if I have posted the message in the wrong
newsgroup.
PW
|