Question:

Is it possible to program a macro to 1) go to a ftp site 2) download a
file 3) unzip that file?

This sounds possible, but I'm going nuts but I don't know how to
begin.

I know that in excel you can go to Data|Import|New Web Query and find
the file...
however I don't know how to go outside of Excel and unzip the file.

Has anyone seen anything like this before?

Rob


--
robsix6
------------------------------------------------------------------------
robsix6's Profile: http://www.excelforum.com/member.php...o&userid=24045
View this thread: http://www.excelforum.com/showthread...hreadid=376564