Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!
Error when using SHELL command to run FTP Files
I am using the following files to upload a batch of PDF files to my website:
FTP_cmd.txt
user
uploads@mywebsite.com
HM7UKZV
binary
Put SampleFile.pdf
quit
FTP_run.bat
ftp -i -s:FTP_cmd.txt mywebsite.com > FTPlog.log
Pause
When I run the FTP_run.bat file directly (through Windows Explorer), it uploads the files w/o error.
However, when I try to run the FTP_run.bat file with SHELL ("c:\uploads\FTP_run.bat")
When I use SHELL ("cmd"), it opens the command window.
FTP_cmd.txt
user
uploads@mywebsite.com
HM7UKZV
binary
Put SampleFile.pdf
quit
FTP_run.bat
ftp -i -s:FTP_cmd.txt mywebsite.com > FTPlog.log
Pause
When I run the FTP_run.bat file directly (through Windows Explorer), it uploads the files w/o error.
However, when I try to run the FTP_run.bat file with SHELL ("c:\uploads\FTP_run.bat")
When I use SHELL ("cmd"), it opens the command window.
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
You've go no pathing on the script file in the batch file.
VBA has a current drive directory and it probably doesn't match the current location of the script file.
Try giving a full path for the script file and see if that resolves it.
Jim.
VBA has a current drive directory and it probably doesn't match the current location of the script file.
Try giving a full path for the script file and see if that resolves it.
Jim.
I should state that all files (FTP_cmd.txt, FTP_run.bat & the files to be uploaded) are in the same directory.
I changed the bat file to ftp -i -s:c:\uploads\FTP_cmd.txt mywebsite.com.
Then I ran the bat file directly from file explorer. Got the same error: "Error opening script file c:\uploads\FTP_cmd.txt.
I changed the bat file to ftp -i -s:c:\uploads\FTP_cmd.txt mywebsite.com.
Then I ran the bat file directly from file explorer. Got the same error: "Error opening script file c:\uploads\FTP_cmd.txt.
Gustav:
I tried using your code, but it did not work. Here is what happened:
1. The command I used in an MS Access subroutine is:
Shell ("cmd /c " & Chr(34) & "c:\data\dinnerdailyapp\ft
2. The Access file is located in the same directory as the FTP_run.bat file and the FTP_cmd.txt file
3. After I run the SHELL command, I get an error message "Error opening script file FTP_cmd.txt".
4. In the attached screenshot of the command window after running the SHELL, it shows a path different from the location of the Access & the "FTP" files.
Contents of the FTP files:
FTP_run.bat
ftp -n -s:FTP_cmd.txt thedinnerdaily.com
Pause
FTP_cmd.txt
user
user@thedaily.com
pwKZ
binary
Put Sample01.pdf
quit
I also tried (unsuccessfully) running the FTP_run.bat file with the path to the FTP_cmd.txt file included:
ftp -n -s:c:\Data\dinnerdailyapp\
I tried using your code, but it did not work. Here is what happened:
1. The command I used in an MS Access subroutine is:
Shell ("cmd /c " & Chr(34) & "c:\data\dinnerdailyapp\ft
2. The Access file is located in the same directory as the FTP_run.bat file and the FTP_cmd.txt file
3. After I run the SHELL command, I get an error message "Error opening script file FTP_cmd.txt".
4. In the attached screenshot of the command window after running the SHELL, it shows a path different from the location of the Access & the "FTP" files.
Contents of the FTP files:
FTP_run.bat
ftp -n -s:FTP_cmd.txt thedinnerdaily.com
Pause
FTP_cmd.txt
user
user@thedaily.com
pwKZ
binary
Put Sample01.pdf
quit
I also tried (unsuccessfully) running the FTP_run.bat file with the path to the FTP_cmd.txt file included:
ftp -n -s:c:\Data\dinnerdailyapp\
You also need the full path to the document. Then it will run:
r:\cd_test12>ftp -n -s:c:\test\FTP_cmd.txt cactus.dk
Connected to cactus.dk.
220 Microsoft FTP Service
200 OPTS UTF8 command successful - UTF8 encoding now ON.
ftp> user
Username xyz
331 Password required
230 User logged in.
ftp> binary
200 Type set to I.
ftp> cd lib
250 CWD command successful.
ftp> put c:\test\test.pdf
200 PORT command successful.
125 Data connection already open; Transfer starting.
226 Transfer complete.
ftp: 241794 bytes sent in 1.66Seconds 145.75Kbytes/sec.
ftp> quit
221 Goodbye.
r:\cd_test12>pause
Press any key to continue . . .
Premium Content
You need an Expert Office subscription to comment.Start Free Trial