This File Name
 

Hi,

Is there a way to create a dynamic filename?

For instance, if I want to create a macro that did:

Windows("THISFILENAME").Activate

but I saved the file under a different name, I would have to edit the
macro or I would get a subscript out of range error. Any help would be
greatly appreciated.

Thanks.


---
Message posted from http://www.ExcelForum.com/

This File Name
 

Try

Windows(ThisWorkbook.Name).Activate
' or
ThisWorkbook.Activate

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"theillknight "
wrote in message
...
Hi,

Is there a way to create a dynamic filename?

For instance, if I want to create a macro that did:

Windows("THISFILENAME").Activate

but I saved the file under a different name, I would have to
edit the
macro or I would get a subscript out of range error. Any help
would be
greatly appreciated.

Thanks.


---
Message posted from http://www.ExcelForum.com/

This File Name
 

Phatchef24 is that you?

--
Regards,
Tom Ogilvy

"theillknight " wrote in
message ...
Hi,

Is there a way to create a dynamic filename?

For instance, if I want to create a macro that did:

Windows("THISFILENAME").Activate

but I saved the file under a different name, I would have to edit the
macro or I would get a subscript out of range error. Any help would be
greatly appreciated.

Thanks.


---
Message posted from http://www.ExcelForum.com/