Hi All

If I create a new workbook, I can assign it to an object variable...

Dim wB as Workbook
Set wB = Workbooks.Add

How can I open an existing workbook and assign it?

Dim wB as Workbook
Set wB = Workbooks.Open "C:\myWork.xls"

Does not work!

TIA

--

Regards,
Nigel

Dim wB as Workbook
Set wB = Workbooks.Open("C:\myWork.xls")

should work


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Nigel" wrote in message
...
Hi All

If I create a new workbook, I can assign it to an object variable...

Dim wB as Workbook
Set wB = Workbooks.Add

How can I open an existing workbook and assign it?

Dim wB as Workbook
Set wB = Workbooks.Open "C:\myWork.xls"

Does not work!

TIA

--

Regards,
Nigel

Many thanks Bob, works a treat.

--

Regards,
Nigel




"Bob Phillips" wrote in message
...
Dim wB as Workbook
Set wB = Workbooks.Open("C:\myWork.xls")

should work


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"Nigel" wrote in message
...
Hi All

If I create a new workbook, I can assign it to an object variable...

Dim wB as Workbook
Set wB = Workbooks.Add

How can I open an existing workbook and assign it?

Dim wB as Workbook
Set wB = Workbooks.Open "C:\myWork.xls"

Does not work!

TIA

--

Regards,
Nigel