I have a macro that is in a “control workbook”. When triggered it get a worksheet from one folder and copies it into itself. Then it runs another macro which formats the sheet and then moves that worksheet to another folder where it will later be mailed along with some other worksheets.
First, I feel that my code in the this top macro could be simplified and written better than I have it now. I would appreciate any advice.
Secondly, I have a couple of other buttons which will be doing the same type of thing as the first except they will be looking for a different excel file and calling another macro which will format the worksheet a little differently.
What I was thinking of doing is using saying some like A= File A, B= File B and C= File C and X= Macro X, Y=Macro Y, and Z=Macro Z etc. Then if Button 1 is pressed, it will use A and X if Button 2 is pressed use B and Y etc.
What would be the best way to write this?
I appreciate any help. I'll be out of my office on Tuesday but will respond on Wednesday.
Bookmarks