calling external routines

[Guest]

I've just converted and old Quickbasic program into excel but i'm stuck on 1
problem which I'm not even sure can be done. I want to call and run an MS DOS
batch file from within a VB macro.

Precisely the batch file is called "importdatafiles.bat' and all it does is
use FTP to tramsfer a few data files from a server to my hard drive.

Is it best (or possible) to call the .bat file and if so how or is there
another way within excel to import the files.

Thanks in advance,

Mike

 

[Guest]

Apologies for wasting your time, a proper search of previous answers solved
my problem with the Shell command.

Mike

 

[NickHK]

Mike,
Check out Shell. You can run anything the system considers an executable.

NickHK