Identifying current window

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Don - 27 Jul 2007 15:51 GMT

How can I change the statement below to use the name of the workbook running
the macro rather than the hardcoded workbook name in that statement?

Windows("workbook_a.xls").Activate

Don

P.S. The above statement is from a macro that I recorded that I want to
change. I know nothing about VB or writing macros. I generally record macros
and than make small changes to fine tune them to my needs.

Reply to this Message

Dave Peterson - 27 Jul 2007 16:13 GMT

Instead of going through the windows collection, you could do:

Thisworkbook.activate

If you have multiple windows into the same workbook, then this kind of thing:

windows(thisworkbook.name).activate

will fail.

> How can I change the statement below to use the name of the workbook running
> the macro rather than the hardcoded workbook name in that statement?
[quoted text clipped - 6 lines]
> change. I know nothing about VB or writing macros. I generally record macros
> and than make small changes to fine tune them to my needs.

Signature

Dave Peterson

Reply to this Message

Don - 27 Jul 2007 18:04 GMT

Thank you.

> Instead of going through the windows collection, you could do:
>
[quoted text clipped - 19 lines]
>> macros
>> and than make small changes to fine tune them to my needs.

Reply to this Message