Hi Folks,
I have some VBA in a MS Access module that properly and successfully executes a shell command that executes a batch file in the following manner:
Shell("C:\runthisfile.bat")
I am trying to actually place the contents of the batch file into the module. The problem is that the batch file is many lines. How would I write that?
Shell("ftp.exe -s:%0)
Shell("open myftpserver")
Shell("username)
...
...
...
probably 100 lines with each line being a separate shell command, but that doesn't work and neither does
Shell(" all lines
")
Is it possible to essentially shell many lines at the same time thereby making it possible to take say 100 lines resident in a batch file and just placing them all in the VBA module with shell command(s) instead of calling out the batch file that resides outside of the ms access file? It seems that I can only do single line shell commands?
Thank you for your assistance,
Joe
I have some VBA in a MS Access module that properly and successfully executes a shell command that executes a batch file in the following manner:
Shell("C:\runthisfile.bat")
I am trying to actually place the contents of the batch file into the module. The problem is that the batch file is many lines. How would I write that?
Shell("ftp.exe -s:%0)
Shell("open myftpserver")
Shell("username)
...
...
...
probably 100 lines with each line being a separate shell command, but that doesn't work and neither does
Shell(" all lines
")
Is it possible to essentially shell many lines at the same time thereby making it possible to take say 100 lines resident in a batch file and just placing them all in the VBA module with shell command(s) instead of calling out the batch file that resides outside of the ms access file? It seems that I can only do single line shell commands?
Thank you for your assistance,
Joe
