How to pass file path dynamically in Invoke VbScript Activity?

Help Studio
, ,
3

@Sanket_Shinde1,

Click on Input Arguments and pass a string argument with your dynamic file path

The image shows a software interface for setting and invoking VBScript with input arguments, highlighting the string variable "strFilePath" as an input argument in the arguments dialog. (Captioned by AI)
The image shows a software interface for setting and invoking VBScript with input arguments, highlighting the string variable "strFilePath" as an input argument in the arguments dialog. (Captioned by AI)881×441 35.1 KB

Inside you script, replace your hard coded file with this code:
Set objWorkbook = objExcel.Workbooks.Open(WScript.Arguments(0))

1 Like