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