Problem running Macros without opening the file

Question

I wanted to run macros using the command prompt, the macros are placed under a sheet in excel. I created a VBScript and let it automatically run in command prompts, but it shows "The macro may not be available in this workbook or all macros may be disabled."

This is my VBA code

enter image description here

This is my VBS

'Create Excel App Instance & Open Xlsm File
Set objExcelApp = CreateObject("Excel.Application")
objExcelApp.Visible = True
objExcelApp.DisplayAlerts = False

'Define Macro File & Path
sFilePathXlsm = "C:\Users\roeyj\OneDrive\Desktop\Intern\Monthly PM\Service Contracts as of 2022 (macro).xlsm"
Set iWb = objExcelApp.Workbooks.Open(sFilePathXlsm)

'1. Run 1st Macro in another Excel
sMacroToRun = "'" & sFilePathXlsm & "'!Sheet3.contract_vba"
objExcelApp.Run sMacroToRun


'Save & Close file
iWb.Save
iWb.Close
objExcelApp.DisplayAlerts = True
objExcelApp.Quit

This is what the command prompt shows

enter image description here

The excel file is opened but the macros don't run, I need help with this.

@braX, i have enabled all the macros settings in excel. Shouldn't be the setting problems, i think there is something wrong in my VBScript — LO ROEY JIA, Jan 18 '23 at 05:31
Please do not post your code as images. No one can copy/paste it then. — braX, Jan 18 '23 at 05:34
If you want a macro to be available to any workbook, then put it in the personal workbook. — Solar Mike, Jan 18 '23 at 06:20
@SolarMike I need the correct codes for me to run the macros in the Sheet using Command prompt — LO ROEY JIA, Jan 18 '23 at 06:59
Try `objExcelApp.Run "'" & iWb.Name & "'!Sheet3.contract_vba"` — Tim Williams, Jan 18 '23 at 07:02
You still have images of code instead of text. Please edit your question to replace them with the actual text. — Geert Bellekens, Jan 18 '23 at 08:01

score 1 · Answer 1 · answered Jan 18 '23 at 07:08

1

Run doesn't want the full path, so try:

 objExcelApp.Run "'" & iWb.Name & "'!Sheet3.contract_vba"

answered Jan 18 '23 at 07:08

Tim Williams

154,628
8
97
125

Problem running Macros without opening the file

1 Answers1