S
Shaka215
Hey all! I have been trying to get answers to this question for quite
some time and I have made some progress, however, I have come into an
interesting situation...I originally was looking to use an Excel based
FTP upload/download VB script to pull information and update
information from a central server for an application I am building
would use. I have found a better solution using a script based FTP
client to do the data pulling...this program I am using can be launched
using the Command Prompt the "Call Shell" function to be exact. I have
however come into a problem with using the Call Shell function. I have
the program stored in the following directory with the exact command
line I need to be issued however when I use the Call Shell function it
creates multiple command windows and doesn't execute the program
correctly...I need some help with getting the exact wording in VBA to
lauch the following...
C:\FTP\VbFTP.exe VbFtp.Txt
The program is vbFTP.exe and the script is vbFTP.txt. The program is
setup to process the script that comes after the program's name
(VbFtp.exe). I have had numerous people attempt to help me with this
problem, however, I am still in need of some assistance getting the
directory and file above to be entered in to COMMAND and have the
program run. It works fine creating a shortcut to the program with the
script text file attached however it's not as simple as dropping a
shortcut to the file in Excel because it just locks up the FTP
program...It works great when I enter the information into COMMAND but
I need Excel to do this for me...ANY HELP IS GREATLY APPRECIATED!! Once
the process has been figured out I will release a new thread that will
provide everyone the ability to use centeralized data for their
applications and will provide a URL to this program I am using. Thank
you so much for all those that have helped and those are going to help.
some time and I have made some progress, however, I have come into an
interesting situation...I originally was looking to use an Excel based
FTP upload/download VB script to pull information and update
information from a central server for an application I am building
would use. I have found a better solution using a script based FTP
client to do the data pulling...this program I am using can be launched
using the Command Prompt the "Call Shell" function to be exact. I have
however come into a problem with using the Call Shell function. I have
the program stored in the following directory with the exact command
line I need to be issued however when I use the Call Shell function it
creates multiple command windows and doesn't execute the program
correctly...I need some help with getting the exact wording in VBA to
lauch the following...
C:\FTP\VbFTP.exe VbFtp.Txt
The program is vbFTP.exe and the script is vbFTP.txt. The program is
setup to process the script that comes after the program's name
(VbFtp.exe). I have had numerous people attempt to help me with this
problem, however, I am still in need of some assistance getting the
directory and file above to be entered in to COMMAND and have the
program run. It works fine creating a shortcut to the program with the
script text file attached however it's not as simple as dropping a
shortcut to the file in Excel because it just locks up the FTP
program...It works great when I enter the information into COMMAND but
I need Excel to do this for me...ANY HELP IS GREATLY APPRECIATED!! Once
the process has been figured out I will release a new thread that will
provide everyone the ability to use centeralized data for their
applications and will provide a URL to this program I am using. Thank
you so much for all those that have helped and those are going to help.