If you have a shared drive, you should just be able to copy the file using
the UNC path. No reason to go to FTP.

--
Regards,
Tom Ogilvy


"Jeff Armstrong" wrote in message
...
We have a shared drive that contains some zip files that I
download daily to process in Excel. I already have my
script opening the zip file and unzipping automatically.
My question is this:

Can I open up a command prompt and start an FTP session to
the shared drive and download the files from within Excel?

This would be great because then I have automated another
step that I have to perform daily.

Jeff