My case is:
In an Excel file "ABC.xls", I have a macro handling with 2 files, 1 is "ABC.xls" and the other is "cde.dbf". The following command will appear in my macro
Windows("ABC.xls").Activate
But sometimes I need to change the filename "ABC.xls" to "DDD.xls" for example, then this macro will be an error. I need to change it manaully to Windows("DDD.xls").Activate to run it smoothly. Anyone know is there a variable that store the current filename? So that I don't need to change the macro every time I change its filename?
Thanks
Power
Power Wong
Every problem will have a solution, the only problem is that can you find it out.