hi
is there a way to copy open workbooka and save as source name
how would i capture original file's name
i cannot hardcode the file name as each day a new file is put into the folder and needs to be processed then copied and saved with the original name
possible the file is updated by power query
the sourcename is column A
is there a way to copy open workbooka and save as source name
how would i capture original file's name
i cannot hardcode the file name as each day a new file is put into the folder and needs to be processed then copied and saved with the original name
possible the file is updated by power query
the sourcename is column A