Running Public Sub in one workbook to run another macro in another workbook

[Andrewstupendo]

I am trying to run a macro in a second workbook by running a public sub macro in the first workbook. I found the following code on the internet, which does not work. I think I am close to solving this, but not close enough. The name of the macro is called "Put_Macros_Together_In_Matter_Names_and_Numbers". And the file path of the SECOND workbook is ("C:\Users\acc\Documents\Macros\Time macro - test.xlsm"). By the way, both workbooks were open when I tried running the macro, but somehow it didn't work. here is the "errant" code:

Please Login or Register  to view this content.

Please let me know if you can fix this.

Best,
AndrewStupendo

[Norie]

Have you tried using Application.Run instead of Call?

By the way, if the other workbook is already open is it open in another instance of Excel?

[Andrewstupendo]

Yes, I did try that but it did not work. Also I am using the macro in question in combination with other public macros. So I have to use a public macro to do this.

[Andrewstupendo]

No both excels are open on the same computer using the same version of excel, if that's what you mean.

[Norie]

Sounds like you do have 2 instances of Excel to me.

What happens if you try using oWb.Application.Run?

That might work as oWb.Application should refer to the instance of Excel that the workbook oWb is open in.

[Andrewstupendo]

I tried the following code, which did not work either:

Please Login or Register  to view this content.

Can someone please help?

Thanks.

[Andrewstupendo]

Also tried this, which did not work either:

Please Login or Register  to view this content.

[xlnitwit]

Hi,

In which module in the workbook is the Put_Macros_Together_In_Names_and_Numbers code located?

[Norie]

Did you try what I suggested?

Please Login or Register  to view this content.

[Andrewstupendo]

The module for the macro "Put_Macros_Together_In_Names_and_Numbers" is located the module in "Sheet 2" with the name "Matters Names & Numbers". Also the name of the workbook is 'Individual Time macro - final version.xlsm'.

[xlnitwit]

Then you must use

Please Login or Register  to view this content.

[Andrewstupendo]

Hello All,
I tried the following two macros, neither of which worked for different reasons.
The first macro did not work because the file path is not correct. I tried different paths for the file (I even put the file on my desktop) and the compiler would not accept the file path coding. here is the first macro with the problem coding in red:

Please Login or Register  to view this content.

I found another macro which does the same thing. The file path seemed OK, but when it came to use the "Application.Run" line of coding, the compiler would not accept it. here is the coding of the second macro with the problem line in red.

Please Login or Register  to view this content.

[Norie]

Any chance you could upload sample workbook(s)?

Click on GO ADVANCED, scroll down and click Manage Attachments.

[Andrewstupendo]

OK. I will edit the workbooks and I will get back to you.

[xlnitwit]

GetObject requires a full path including the file name. Thus the first code needs to read

Please Login or Register  to view this content.

The second code is missing some concatenation

Please Login or Register  to view this content.

I might also suggest that your code belongs in a regular module rather than a worksheet code module.

[Andrewstupendo]

This is not working because it is just not possible to find the correct file path for the second workbook, given the network setup that I have. I am therefore closing this thread as unsolved. No one's fault except the network's.