View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Gary Keramidas[_2_] Gary Keramidas[_2_] is offline
external usenet poster
 
Posts: 364
Default XL doesn't like my path?

i'll just use something like this:

dim fPath as string
dim fName as string

fPath = "N:\My Documents\Excel\"
fName = fName = "Abuse in Care original.xls"

Workbooks.Open Filename:=fPath & fName

--


Gary

"davegb" wrote in message
oups.com...
I'm trying to tell XL which workbook to use:

Set wbOrig = H:\AllDocs\CFSR PIP DD\SFY 06 Q1\Records Base\Abuse in
Care original.xls

but it doesn't like my backslash. I searched in the NG, but couldn't
find a similar example. So how do I tell it the path and workbook name?

Thanks!