calling external routines

M

Mike

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
 
M

Mike

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

Mike
 
N

NickHK

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

NickHK
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Outlook Backup issues 0
Active Content in this file is blocked issue 1
Special problem deleting a folder 3
React JS Outlook Add-in - VS Code + WebPack - Unable to call external Web Service - CORS Issue 0
Outlook Add-in - Javascript based using React JS - VS Code + WebPack - Unable to call external Web Service 0
Running Batch File from within Excel 5
batch file to ftp code not running - please help! 0
Can't close old pst file 2

Top