Prev: Active.Paste Error
Next: lookup list
From: Peter on 14 Apr 2010 11:10
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?



From: Rick Rothstein on 14 Apr 2010 11:30
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" <noMorespam(a)MSUK.com> wrote in message
news:e2kenS#2KHA.4540(a)TK2MSFTNGP04.phx.gbl...
> 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?
>
>
>
 | 
Pages: 1
Prev: Active.Paste Error
Next: lookup list