Hi there,
I’m working with an existing Notes application. It has a form that is used to prepare software shipping order for our customers. It uses a table where software part numbers are pulled from another form and populated.
If multiple software are being shipped it could have multiple rows (every cell of the table is a unique field). One of the column has the file path of the software. It allows upto 54 software to be entered on the same order and there is a unique field for file path of each of the parts entered.
The requirement is to have following action buttons that could be used after the order form has been saved:
- download the software from their source location into a separate directory using a batch file
Sample command for download:
download
I was going to use the Shell command to launch the batch file.
- assuming a single software was being shipped, this is what i thought of (for doing the download part):
Sub Click(Source As Button)
Dim result As Integer
ExeDir="\\C:\<directory name where download exe file resides>"
result=Shell((ExeDir + "download <file path>"), 1)
End Sub
The problem is how do i capture the file path field info in the form into ExeDir above (and eventually loop it from one row after another) and add it between the quotes?
Thanks for all your help!
Ayaz