So, I've done a lot of research on this and my code isn't working still. As per the title, the problem is this:

I pull a data report off of a website, this report is downloaded as an .xlsx file. I created a macro on the ribbon so I when I click it, it will then open another workbook and run that macro. The code I'm using is as below:

```
    Option Explicit
    Sub NotHardAtAll()

    Dim ws As Worksheet,
    Dim wb As Workbook

    Set wb = ActiveWorkbook

    Set ws = ActiveSheet

    Workbooks.Open Filename:="C:\Users\a0c27n\Desktop\Projects\incident_extended_report1.xlsm"

    'With Sheets("Sheet4").Activate  '*Not sure if this is enter code here 
     necessary...at all*

    Application.Run "!ADDHMKRFID"
    'End With

End Sub

```

I've tried putting the path before the macro (i.e. `Application.Run"'incident_extended_report1.xlsm!ADDHMKRFID"`) but it doesn't work either\*

I'm aware, at least form the research I've done, that I *should* be able to just use the 'Application.Run' Method, however I couldn't get it to access the correct sheet.

When I run the Macro, it pulls a Run-time error '1004' error, a '400', or the it pulls the most is: "Cannot run the macro '!ADDHMKRFID'. The macro may not be available in this workbook or all macros may be disable."

The file that I'm trying to pull the macro from is below:

Workbook name: **incident\_extended\_report1.xlsm**

Worksheet name: **Sheet4 (TEST MACRO)**

Macro Name:
**Sub ADDHMKRFID()
End Sub**

I understand that the C:\ is not a shared network, the one I will be working out of will be the S:\, however I'm not sure how much information I can post due to confidentiality.
Please ask for any clarification or questions you may have. I've been stuck for a bit and am not sure what I'm doing wrong. Thanks in advance!