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

  • by

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.


Leave a Reply

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