This is a 3 parter. Sorry but I am kind of new to the VBA aspect.
I have a macro that automatically opens 21 files to update. How do I make the filenames, passwords, and tab names variables? I want to put them all at the top of the macro so I only have to change once instead of 21 times. Kind of like making a template.
Thanks!!
I have a macro that automatically opens 21 files to update. How do I make the filenames, passwords, and tab names variables? I want to put them all at the top of the macro so I only have to change once instead of 21 times. Kind of like making a template.
Thanks!!