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/