Calling macro from another workbook

Hi,

I open a .csv file and run a personal macro on it to format the data. It then opens another file, in which I want it to run a macro within the workbook.
I have the below code, but his keeps giving me the error
"Run-time error '1004': Cannot run the Macro '!MakeChanges'. The macro may not be available in this workbook or all macros may be disabled."

I can enter the workbook and manually execute the macro (therefore macros are not disabled), but want it to automatically run, from my personal macro.

This is my code

Public Sub MakeChanges()

 Dim  toolWB As Workbook

 Workbooks.Open Filename:= _
        "C:\Users\me\Desktop\DataTest.xlsm", Password:="abcde"
    
 Set toolWB = ActiveWorkbook


toolWB.Application.Run ("!newiTime")

What is causing the error and how can I fix this? Any help, greatly appreciated!!

Hi,

How are you calling the MakeChanges routine? If you are using Run, you should include the workbook name- in single quotes- before the exclamation mark.

Hi,

I have amended it, as per your suggestion and no longer get the pop up error. However, it just closes the workbook that has the macro in it instead and does not run the macro.

Public Sub MakeChanges()

 Dim toolWB As Workbook

 Workbooks.Open Filename:= _
 "C:\Users\me\Desktop\DataTest.xlsm", Password:="abcde"
 Set toolWB = ActiveWorkbook
 Application.Run ("'DataTest.xlsm'!newiTime") 

End sub

First, please use code tags when posting code, per the forum rules.

Second, the error you mentioned in your original post, related to running the macro you posted, not the macro in the workbook you are opening- which is why I asked how you were running the posted macro. There is nothing in what you have posted that closes any workbooks so I can't comment further. Perhaps you could post all the relevant code?

@garveyarmy
I have corrected your posting to include code tags. I can see you attempted to do so, but missed the point on placing them on either end of your code. Highlight your code and then click on the # button to ensure that code tagging is enacted.

In an effort to help others who may encounter a similar situation, please explain what you found as your error and how you corrected it. Many people use this forum as a database of information when attempting to seek their own solutions.