This File Name

T

theillknight

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.
 
Top