I have set a button to run Marco for the subject action . However, the file name of Workbook A will change every day. I need to correct the file name of Workbook A in Marco before click button. I want to skip the correction step. Please help.
Thank you.