Call a Macro from another workbook

wizard94

New Member
Joined
Feb 20, 2019
Messages
4
Hi there - just wondered whether someone could help me as my brain is currently fried ..

I have a workbook named KPI_DASH. This collates data collected from various other workbooks i.e BookA. The KPI_DASH workbook is hidden to the user and they wouldn't open it.

Within KPI_DASH is this macro:

Sub AromaHours()


Worksheets("HoursAroma").Activate


Dim cell As Range
For Each cell In Range("B2:AA9")
If cell.Value > 0 Then
cell.Copy
cell.PasteSpecial xlPasteValues
End If
Next
End Sub

From the BookA workbook, on a button press, I need it to open the workbook KPI_DASH in the background and run the above macro. This is what I have so far:

Sub SubmitHours()


Application.DisplayAlerts = False
Application.ScreenUpdating = False
Workbooks.Open Filename:="\root\KPI_DASH.xlsm"
Application.Run "KPI_DASH.xlsm!AromaHours"


End Sub

However I am getting a Run-time error '1004'. Can someone help please?

Thank you!
 

Some videos you may like

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

mumps

Well-known Member
Joined
Apr 11, 2012
Messages
8,755
Try:
Code:
Application.Run ("'KPI_DASH.xlsm'!AromaHours")
 

Watch MrExcel Video

Forum statistics

Threads
1,089,969
Messages
5,411,566
Members
403,379
Latest member
aarango

This Week's Hot Topics

Top