Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbooks.Open with a network path
Hello
I'm trying to do a Set SrcWrkBook = Workbooks.Open(\\networkdrive\ folder one\ folder two\filename.XLS, True, True) I assume the white spaces and perhaps the \\ are giving me issues. How do I get around this? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbooks.Open with a network path
That first argument (your path and filename) needs to be a String value, so
it needs quote marks around it. Also, I'd be willing to bet that there are no leading spaces in front of your folder names. My guess is your line should look like this (note, this line is long, so I expect it will word wrap at a required blank space)... Set SrcWrkBook = Workbooks.Open("\\networkdrive\folder one\folder two\filename.XLS", True, True) -- Rick (MVP - Excel) "Peter" wrote in message ... Hello I'm trying to do a Set SrcWrkBook = Workbooks.Open(\\networkdrive\ folder one\ folder two\filename.XLS, True, True) I assume the white spaces and perhaps the \\ are giving me issues. How do I get around this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Workbooks.Open with out full path help needed. | Excel Discussion (Misc queries) | |||
links on network needs redefine path whenever open | Excel Programming | |||
XLapp.Workbooks.Open is not opening XL app but path is correct | Excel Discussion (Misc queries) | |||
Workbooks.Open fails when using a full network path.... | Excel Programming | |||
Open Workbook using URL instead of network path | Excel Programming |