Defining and setting workbook object variable?

[Granite-Granny]

I'm working on my first macro that works over multiple workbooks and I'm stuck at line 1. I obviously have the syntax wrong but I can't figure out why this code doesn't work. Do I need the full pathname for the workbook name?

Please Login or Register  to view this content.

I know... I know, this should be basics 101!

GG

[xladept]

If you have a Training2.xlsx active then your code should run - are you getting a subscript error?

[AB33]

Nothing wrong with the syntax. You might not have a workbook called Training2.xlsx in the workbook you are working.

Please Login or Register  to view this content.

[HaHoBe]

Hi, AB33,

You might not have a sheet called Training2.xlsx in the workbook you are working.

Not so sure that I can understand what you refer to but I have only limited knowledge of VBA, could you please explain?

Please Login or Register  to view this content.

should raise a RTE as wb is dimmed as workbook?

Ciao,
Holger

[AB33]

I would have, but since you are a person with full of sarcasm, I have not desire nor the intention to communicate with you. I have made this clear on many occasions( In case you missed one of them)

"I have only limited knowledge of VBA"

[Granite-Granny]

If you have a Training2.xlsx active then your code should run - are you getting a subscript error?

Ah ha! I didn't have Training2.xlsx open. Doh! I looked at this code for about an hour trying different syntax and the answer was simple.

Please Login or Register  to view this content.

I'll have to make sure I error proof the code in the event I get this error in 6 months and I forget the reason

I suppose there is no way to work on a closed workbook, it has to be open right?

GG

[AB33]

Follow this link

http://www.rondebruin.nl/win/s3/win024.htm

[Granite-Granny]

Thank you for the help and the link.

GG

[HaHoBe]

Hi, AB33,

maybe have another look at the code from TO and your sample - having a variable dimmed as workbook and trying to assign a worksheet does it make necessary to communicate I´m afraid as Run-Time Error 13 should be raised when trying to run the code line.

Ciao,
Holger