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

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

Mike

"Mike" wrote:

> 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

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

NickHK

"Mike" <(E-Mail Removed)> wrote in message
news:72A38EE9-8022-4739-8484-(E-Mail Removed)...
> 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