Hi! i'm trying to build a macro that will change the files a macro effects. For example

i have a macro that's doing things to testfile.xls but i want to run a macro that will allow a user to type a name in a cell, say "apple" and have a macro run that will go in and edit the macro that runs for testfile.xls and change the name to apple.xls so that macro will now run on the apple.xls file.

OR
Alternatively a macro or VBA that will run when the file with the macro's open that will have a box that will request to enter the name of the file i'm working on and when you click ok it will then change the file names on the macro's.
is this possible?