using psftp through VBA

[Guest]

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

 

[Dirk Goldgar]

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.

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.

 

[aj]

Dev Ashish's site

http://www.mvps.org/access/modules/mdl0015.htm