Trying to run a macro in another workbook

[JKK22]

Hello, I need data from another workbook updated, before doing another process.
I created the below macro in my current workbook , to open up the other workbook, run the macro called "GetPSDataMon" within that other workbook, and close that other workbook.
It opens up the workbook fine, but it won't run the macro

Sub Update0901Fri()

Dim fileName As String
nPath = "\\Swib\root\ShrIOFAFinance\SIF\SIF Earnings\"
fileNameString = "09.1 AveBalRecalc" & ".xlsm"
fileName = Dir(nPath & fileNameString)

Workbooks.Open nPath & fileName
Sheets("Running_Report").Select
Call GetPSDataMon
Workbooks(fileName).Save
Workbooks(fileName).Close
End Sub

 

[HaHoBe]

Hi JKK22,

try

Application.Run ("'" & fileName & "'!GetPSDataMon")

Ciao,
Holger

 

[JKK22]

Hello
This worked! I removed: Call GetPSDataMon
and replaced it with : Application.Run ("'" & fileName & "'!GetPSDataMon")

thank you

 

[HaHoBe]

Hi JKK22,

glad we could help on this one.

Holger