Opening a 2nd Workbook and Running Macro

Hey everyone,

I'm hoping someone can help me out troubleshooting some code I found online (from Ken Puls).

Context:
- I have 2 workbooks ('Master' and 'Dash'). The first ('Master') compiles and summarizes data and the second ('Dash') imports this summarized data and presents it in a more 'user friendly' format.
- I have a series of macros that run in 'Master' and I have a macro in 'Dash' that imports from 'Master' to 'Dash'

Purpose of desired macro:
- I would like to integrate the macro that imports from 'Master' to 'Dash' (currently residing in the 'Dash' workbook) into the a macro in the 'Master' workbook.

Solution so far (which results in an error):
-The following code which I tried to run from 'Master' is intended to open 'Dash' and run its 'Exprt' macro. Unfortunately it results in an error ("Run-Time error '1004': Cannot run the macro [...] The macro may not be available in this workbook or all macros may be disabled") at this line:

Please Login or Register  to view this content.

The complete macro code is below:

Please Login or Register  to view this content.

Any ideas to fix this issue? I've tried a few variation of that line causing the error and nothing worked so far.

Thank you,

Goeff.

Hi John55,

Thanks for trying to help out. Unfortunately, I the same error...

I'm not sure what it is that's wrong. I'll keep looking into it.

Geoff.

I've managed to get passed that error but then I encountered another error and the more I think about what I need the more I realized this one might not do the trick. I need a macro that will open another workbook and run a macro within that newly open workbook and I don't think this code does that...

If you happen do know what code would do this, please share, otherwise no worries and good day!


Geoff.

Thanks John. That was the code I tried actually. So you also think it's the code I need... Ok, I will go back to it and try to get running again!

Cheers,

Goeff.

Hi John,

Thanks for your advice. I created a test file to run the msgbox macro as you suggested and was able to correct the new issue that I had run into and the macro ended working fine. Unfortunately, the macro that I am calling up (in "Workbook 2") from "Workbook 1" is running into an error and I think it is because it this macro in "Workbook 2" was meant to be run when "Workbook 1" was closed.

Basically, it think I need to fix this by reorganizing my macros! As it is, "Workbook 1" opens a macro in "Workbook 2" and this macro in "Workbook 2" tries to open "Workbook 1" to import some data but run's into a problem because "Workbook 1" is still open. It seems like a bit of a mess but my knowledge of excel vba is limited so this is what I've been dealing with :S

Thanks again! I'll go and try to solve this new problem that came up...


Geoff