using psftp through VBA

C

cmack

Hello, everyone. I have been researching this for a while but I need a
little assistance. Can someone tell me how I can use secured ftp (psftp)
with VBA. I want to make it seemless to the end user, so, I need to supply
an upload.scr file that contains the commands as well as the username and
password. I know the psftp commands, I just need help calling the psftp.exe
command with the .scr file.

Thanks.

christian
 
D

Dirk Goldgar

cmack said:
Hello, everyone. I have been researching this for a while but I need
a little assistance. Can someone tell me how I can use secured ftp
(psftp) with VBA. I want to make it seemless to the end user, so, I
need to supply an upload.scr file that contains the commands as well
as the username and password. I know the psftp commands, I just need
help calling the psftp.exe command with the .scr file.
Click to expand...

I've never heard of psftp, but if it can be run from the command line,
and you can specify the username, password, and script file on the
command line, then you should be able to use the Shell statement to run
it.
 
Top