Running a Subroutine on Open ABNORMALLY

[hicksi]

I have Excel as my data with a set of forms (ie, a system utilising Excel - because I CANNOT use C# or VB# due to company policy).
Usually it starts and displays the main form... NO PROBLEM
It also contains code-save & sheet-save subroutines. I want to run those (without running the forms).

Is there a command-line version such as

EXCEL MYFILE.XLSM -RUN ExportCode

which will open MYFILE.XLSM and run my ExportCode subroutine and then exit?

 

[Fazza]

hello

like this question & answer? https://answers.microsoft.com/en-us...s-closed/b262db58-9922-4593-843d-9ed4eeca3f75

regards

 

[hicksi]

hello

like this question & answer? https://answers.microsoft.com/en-us...s-closed/b262db58-9922-4593-843d-9ed4eeca3f75

regards

SO, you're saying that I need a small Excel program that opens MYFILE.XLSM and runs my extract routine?

 

[hicksi]

And I just found THIS code on https://wellsr.com/vba/2015/excel/run-macro-without-opening-excel-using-vbscript/

<code class="language-vb" data-lang="vb">
'Code should be placed in a .vbs file 
</code><code class="language-vb" data-lang="vb">Set objExcel = CreateObject("Excel.Application")
objExcel.Application.Run "'C:\Users\Ryan\Desktop\Sales.xlsm'!SalesModule.SalesTotal"
objExcel.DisplayAlerts = False
objExcel.Application.Quit
Set objExcel = Nothing</code>

Haven't tried it (yet)