(Solved) – Open file, rename file to variable and be able to activate window throughout macro using new name

  • by
(solved)-–-open-file,-rename-file-to-variable-and-be-able-to-activate-window-throughout-macro-using-new-name

I realize this is probably a simple task but I am having issues activating files in my code. I need to have the user choose a file from a pop-up box, have the file opened, and then be able to rename the file so I can activate it periodically in my macro without worrying about the file name being different each time the macro is run.

I am relatively new to VBA and am taking a course online to get better. I would appreciate any help with this.

Thanks.

Leave a Reply

Your email address will not be published. Required fields are marked *