Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
calling external routines
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
calling external routines
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
calling external routines
Mike,
Check out Shell. You can run anything the system considers an executable. NickHK "Mike" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA routines - help please | Excel Discussion (Misc queries) | |||
CALLING A RANGE OF CELLS FROM EXTERNAL SOURCE | Excel Discussion (Misc queries) | |||
calling excell from an external program | Excel Programming | |||
Calling sub routines | Excel Programming | |||
calling an external vbs file on the worksheet close operation | Excel Programming |