Referencing workbooks

[pmguerra]

Hi!

I'm trying to use a reference to a Workbook using the "Set" statement, as I normally do for a worksheet

Example

Please Login or Register  to view this content.

My code is

Please Login or Register  to view this content.

I get a Subscript out of Range error here...

Any suggestions?

Thanks in advance!

[chergh]

You've got "workbook" instead of "workbooks"

[pmguerra]

Yes, I noticed that too. That's not the problem.

The problem is that the Set statement does not work with complete file paths or even with closed workbooks.

Is there a way to bypass this?