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!!
Bookmarks