Is it possible to use the value of the file and folder name in a
macro?

For example, when you rename/copy a file you want the following code
to change:

Windows("2007 Accounts.xls").Activate

If you copy the file containing the macro it will want to activate the
old file and it should activate the new file.

Cheers,

Harold