Source of Excel File

[rahulbassi]

Hello All,

How can we know whether the excel file is opened from a batch file accessed through Command prompt Or manually by double click.
Need to call different functions based upon this condition.

Thanks in advance.

Thanks,
Rahul

 

[rahulbassi]

Just found the solution to old problem. Sharing here for others...

 arrayArgs = Split(CmdLine, "/e/")

 If UBound(arrayArgs) > 0 Then        'Get the string Paramters
        arg_exist = True
    Else
        'There are no parameters; Opened manually
        arg_exist = False
    End If