How can I run FTP using VBA in Access 2007

[BCarter]

I have an Access 2007 program that formats a file then needs to FTP it to a
3rd party. I've used FTP from a batch program with the parameters in a text
file but I can't figure out how to call FTP from within Access 2007 using VBA.

 

[Stuart McCall]

I have an Access 2007 program that formats a file then needs to FTP it to a
3rd party. I've used FTP from a batch program with the parameters in a
text
file but I can't figure out how to call FTP from within Access 2007 using
VBA.

Try my FTP Client if you like:

http://www.smccall.demon.co.uk/Downloads.htm#FTPClient

It's well commented so you should be able to work out what to do.

 

[John W. Vinson]

Try my FTP Client if you like:

http://www.smccall.demon.co.uk/Downloads.htm#FTPClient

It's well commented so you should be able to work out what to do.

Go for it. I've used Stuart's excellent routine for years and found it very
straightforward.

 

[Stuart McCall]

Go for it. I've used Stuart's excellent routine for years and found it

very
straightforward.

Thanks for your kind words, John. Glad it's been of use to you.