Scripting Q&A
Q: How can I automate the FTP process so it runs on scheduler without user intervention? A: The FTP.EXE (File Transfer Protocol) command line utility comes standard with the Windows Operating system. Because it's a command line utility, it allows for many options to be entered at run time (simply enter FTP /? at the command prompt for a complete list). When using the -s: filename switch allows for the commands to be read from the filename specified. For example, first create a text file called myFTP.prm with the following commands: open www.myftpsite.com myUserID myPassword prompt off binary mput myfile *.txt From a command line, execute FTP -s: myFTP.prm . Please note there's no specific extension for file containing the FTP commands. For more info on this, please visit http://support.microsoft.com/kb/96269 Q: How can I execute a command line utility from with a VB Script? A: The CMD.EXE is a command line utility used for running other command