Open Workbook Assignment

[Nigel]

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

 

[Bob Phillips]

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]

Many thanks Bob, works a treat.

--

Regards,
Nigel
(e-mail address removed)