VBA: Is it possible that 3 macros workbooks into one workbook macro?

[vbanewbie68]

Hello

I have 3 macros workbooks ( 3 macro files).

The question is, is it possible to add 3 macros (workbooks) files into one macro workbook? Ideally I would like each tab to have its own macro to run reports.

I have 3 different types of data files downloaded from a platform in CSV format. I import data into a macro, then into a report, and add extra columns.

Or do you have a better idea on how to do it?

Thank you

Best regards

V

 

[vbanewbie68]

Wherever you want the code to run against that sheet.
I have not tried to analyze your code (it would be very difficult to do without all the data) to know where you want things to run.

However, note that in your code, you have sheet references like this:

ActiveWorkbook.Sheets(1).Cells.Copy targetRange

That is referencing the first sheet in the active workbook, regardless of name.

If you wanted it to reference the "Regular" sheet, then you would need to change that, to something like:

ActiveWorkbook.Sheets("Regular").Cells.Copy targetRange

I got it now and I think it works for Regular tab when I clicked its Quick Access button to run but it run for each tab.

See the attached for example.

For the Thankyou tab and Upgrade tab - those will have different codes and should have different Quick Access button for each.

How do I fix that?

Regards

 

[Joe4]

If you want to use the same code for all three tabs, instead of entering in the sheet name, you can either remove all Sheet name references, or use "ActiveSheet", and then it will just run against whatever the active sheet is. So you don't need 3 different copies of the same code then.

 

[vbanewbie68]

If you want to use the same code for all three tabs, instead of entering in the sheet name, you can either remove all Sheet name references, or use "ActiveSheet", and then it will just run against whatever the active sheet is. So you don't need 3 different copies of the same code then.

I got it now so it works how I wanted in that way. So thank you for your help on this matter which is much appreciated it!
best regards
Rej

 

[Joe4]

You are welcome.