Feb 27 2022 10:17 PM
this file will change name according to the value in cell C2.
after the file is saved i need to update a different file with some simple copy and paste. the problem is that the macro enter in debug mode when execute the line in blue. i believe because the file name change and it wont find the named window any more. so i presume i need the window name in the macro to change when i change the file name or the cell value in C2.
if someone can help me to modify the macro it will be highly appreciated
thanks again for your time
Feb 28 2022 03:45 AM
SolutionChange Windows("FFFFFFFFF.xlsm") [I didn't count the Fs] to ThisWorkbook
Mar 06 2022 05:37 PM
Feb 28 2022 03:45 AM
SolutionChange Windows("FFFFFFFFF.xlsm") [I didn't count the Fs] to ThisWorkbook