You have a few options

1. Use the Wininet library - you can look on the msdn and see examples of
how it works. This means writing vba that calls Win32 api functions - not
for beginners.

2. Use vba to create a windows scripting host object and use that. Search
this newsgroup for my name or the topic "Shell Function - Execute DOS
Command" and you can see some examples.

Neither is a great way of doing this, if you are an experienced developer I
suggest option 1, if not then go with option 2.

Good luck.
--
http://www.alignment-systems.com


"Mac Lingo" wrote:


"JLGWhiz"

Thanks for the input. That's interesting, but not what I am trying to do.

I need to read directories off the ftp site to compare dates between what's
stored and what's on my computer to see if a file needs to be backed up to
the site. So I really need to be able to send instructions to the FTP
program and retreive the resulting text.

Mac