Run macro w/ relative reference for File name (changes monthly)

[arndtmiles]

Each month I update/change the file name and have had do manually go in and edit all macros. Is there a way to avoid this? Also, from what I've seen online, many recommend using "ActiveWookbook" or something similar....this will not work for me as I have macros pulling from multiple workbooks at a given time; meaning the active workbook changes as it jump in and out of reports collecting data for my one report.... Any help is much appreciated!

 

[Joe4]

Without understanding the interaction between these workbooks, what is available, and what is chosen, it is quite hard to say.

If you were doing something that is like comparing this month to last month's, one way would be to write a macro that open's up this month's report and makes a copy named "ThisMonth", and opens up last month and makes a copy name "LastMonth". Then have your macro use these two copies to do what it needs (since those names will never change).

Likewise, you could have the macro prompt the users to select/enter the names of the files to work with, and then use VBA to dynamically capture and reference those file names in the VBA code.

 

[Oeldere]

delete post