Macro copying from WB to WB

Hello

I have a macro that I want to use in 20 different workbooks that gathers data from another excel file that is created daily. Each workbook series name changes monthly.

So I need to have the macro to work regardless of the workbook name. The problem is I need the macro to know to go to the data daily sheet and back to the Main workbook regardless of the Name. Like a default setting to activate workbbook maybe something like

Windows("whereever the macro was is activated from to go back ").Activate

instead of like this in the code

Windows("Main235 Feb 08 Ver 6.xls").Activate

the code I have is below

Please Login or Register  to view this content.

Try setting the name of the active workbook to a variabe prior to opening the other workbook:

Please Login or Register  to view this content.