Getting command-line parameters passed to the EXE file

Purpose: getting command-line parameters passed to the EXE file

When you run the EXE file, you can pass command-line parameters to it. For some reason, your VBA code may need to retrieve values of these parameters.

Insert the following code:

Public Function ReadParamStr1()
Dim XLSPadlock As Object
On Error GoTo Err
Set XLSPadlock = Application.COMAddIns("GXLSForm.GXLSFormula").Object
ReadParamStr1 = XLSPadlock.PLEvalVar("ParamStr1")
Exit Function
Err:
ReadParamStr1 = ""
End Function
 

 

You can then call the function:

Sub Test_Param()
   MsgBox ReadParamStr1()
End Sub
 

 

This code shows a ParamStr1 variable. This variable tells XLS Padlock to return the value of the first command-line parameter. For the 2nd, use ParamStr2 and so on. Up to 3 parameters are handled: others are ignored.