How to run a macro from another workbook?

[amarendra19]

I have two excel reports. One excel Report named as Report1.xlsb, contains a button called "Apply Filters". I want to click that button by writing a macro in another workbook. I tried to click the button by using the name used in the macros available in Report1.xlsb.
I have tried with below code. But its not working. Its throwing below error

Please Login or Register  to view this content.

Please advise me if i missed something.

[mojo249]

Forecast Operational Report ES.xlsb' must be open to run any code within it.

[royUK]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

mojo249, please help us with the Rules by not answering a question that obviously infringes them.

[amarendra19]

Hi,
I have written VBA Macro for this which is in some other Excel. And my report is different excel.
I am virtually opening the report excel sheet and trying to Click the "Apply Filter" Button in this sheet. Then i will put the timer before clicking the button and then put the end timer.In this way i will calculate. But below code is not able to click the "Apply Filters" button on that sheet. Please advice me if i miss somthing.

Please Login or Register  to view this content.