Run-time error '1004': Cannot run macro VBA

[NuMbErSNeVeRLie]

I am having trouble running a macro that is in another WB. This worked previously, but now doesn't seem to work... Please help!


Sub RunTestTemplate()
'Establish Variables
Dim RMPath As String
Dim TestFile As String
Dim CorpGrpNum As String
Dim Macro1 As String
Dim Macro2 As String
Dim Macro3 As String
Dim x As Integer
Dim SavePath As String
Dim FileNameLen As Long
Dim CallPath As String
Dim fso As Object
Dim Revenue As Worksheet
Dim Manual As Worksheet
Dim Experience As Worksheet
Dim Ratebook As Worksheet


Set fso = CreateObject("Scripting.FileSystemObject")


'Open and Run Rating Model

'Define Some Variables
TestFile = ActiveWindow.Caption
RMPath = Worksheets("Revenue Calculation").Range("G2").Value
CorpGrpNum = Worksheets("Revenue Calculation").Range("B14").Value
Set Revenue = Worksheets("Revenue Calculation")
Set Manual = Worksheets("2016 - 2020 Manual RAF")
Set Experience = Worksheets("2017 - 2020 Experience RAF")
Set Ratebook = Worksheets("Ratebook v3 by county")

Workbooks.Open Filename:=RMPath, ReadOnly:=False


If Revenue.Range("B6").Value = "Renewal" Then
Worksheets("BlockSummary").Visible = True
Worksheets("BlockSummary").Range("C2").Value = "On"
End If
Worksheets("RenewalInputScreen").Range("B5").Value = Revenue.Range("B14").Value


Macro1 = "!RenewalGroupInfo"
Macro2 = "!RenewalBuild"
Macro3 = "!RunPricing"

Application.Run "'" & RMPath & "'" & Macro1
Application.Run "'" & RMPath & "'" & Macro2


RMPath is the filepath... All names and filepaths have been checked and rechecked.

Thanks!

 

[Yongle]

In future, please use code tags when posting code
- click on # icon above post window and paste inside the code tags
- using code tags formats it etc which makes it easier to read

Replace

Application.Run "'" & RMPath & "'" & Macro1
Application.Run "'" & RMPath & "'" & Macro2

with

Dim s1 As String, s2 As String
s1 = "'" & RMPath & "'" & Macro1
s2 = "'" & RMPath & "'" & Macro2
Debug.Print "s1", s1
Debug.Print "s2", s2
Application.Run s1
Application.Run s2

Look in the immediate window (view with {Ctrl} G ) to see if the strings s1 & s2 are correct

Is the other workbook open when macro is run?

 

[NuMbErSNeVeRLie]

Thank you for the posting tip.

s1 & s2 are correct.

The other wb is open.

Thanks!

 

[Yongle]

Mapping problem??? Try this:

Are both workbooks on a local drive?
- if not, put a copy of both workbooks there, amend all paths required to run them locally and run...

If it fails to rum locally, then there is a problem in the code

 

[Fluff]

Is the code you posted, the complete code, or have you left parts out?
If it's the complete code, step through the code using F8. What happens when you get to the first Application.run line?