How to download files from FTP via excel macro

Hi all, I realize perhaps my last post was little confusing..

I am having some difficulty putting below process together.

I want to create a macro in excel that upon running it, it will download 3 files from FTP server onto my specified shared drive.

Below are the steps I attempted but seems, but it doesn't seem to work.. Any help suggestions would be greatly appreciated

Thanks so much


1) I created (test.bat) file

Please Login or Register  to view this content.

2) I set up a macro in excel with: RetVal = Shell("H:\test.BAT", 1)

However when I run the macro, it just runs everything in a sec and nothing happens..

Am I missing something? My G drive is a shared drive..I would prefer the files to be downloaded there but otherwise I assume its default to my C drive?

anyone any thoughts?