XL doesn't like my path?

[davegb]

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!

[Dave Peterson]

If wbOrig is a string, then you don't need Set:

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

And you need double quotes around the string.

If wbOrig is a workbook object:

Dim OrigName as string
dim OrigWkbk as workbook 'I like more info in the variables

OrigName _
= "H:\AllDocs\CFSR PIP DD\SFY 06 Q1\Records Base\Abuse in Care original.xls"

set OrigWkbk = workbooks.open(filename:=origname)


davegb wrote:
>
> 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!

--

Dave Peterson

[Kletcho]

set wbOrig = Workbooks.Open(filename:="H:\AllDocs\CFSR PIP DD\SFY 06
Q1\Records Base\Abuse in
Care original.xls")

[Kletcho]

Or if it is already open
set wbOrig = Workbooks("H:\AllDocs\CFSR PIP DD\SFY 06 Q1\Records
Base\Abuse in Care original.xls")

[Gary Keramidas]

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" <[email protected]> wrote in message
news:[email protected]...
> 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!
>

[Dave Peterson]

If it's already open, you can't have the path:

set wbOrig = Workbooks("Abuse in Care original.xls")



Kletcho wrote:
>
> Or if it is already open
> set wbOrig = Workbooks("H:\AllDocs\CFSR PIP DD\SFY 06 Q1\Records
> Base\Abuse in Care original.xls")

--

Dave Peterson

[davegb]

Dave Peterson wrote:
> If wbOrig is a string, then you don't need Set:
>
> wbOrig _
> = "H:\AllDocs\CFSR PIP DD\SFY 06 Q1\Records Base\Abuse in Care original.xls"
>
> And you need double quotes around the string.
>
> If wbOrig is a workbook object:
>
> Dim OrigName as string
> dim OrigWkbk as workbook 'I like more info in the variables
>
> OrigName _
> = "H:\AllDocs\CFSR PIP DD\SFY 06 Q1\Records Base\Abuse in Care original.xls"
>
> set OrigWkbk = workbooks.open(filename:=origname)
>
>
> davegb wrote:
> >
> > 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!
>
> --
>
> Dave Peterson

Thanks everyone! I should have mentioned that wbOrig is a workbook
object. Got it worked out!