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