Running a batch file from Excel VBA

  • Thread starter Thread starter verizon
  • Start date Start date
V

verizon

Hello

My macro creates text files that, subsequently, I would like to
automatically run the batch file which saves them to a remote location
(ftp).

Is it possible for VBA to run an outside program?

W
 
Hello

My macro creates text files that, subsequently, I would like to
automatically run the batch file which saves them to a remote location
(ftp).

Is it possible for VBA to run an outside program?
Click to expand...

Yes. See on-line help for the Shell function, a summary of which is
below:
--------------------------------
Shell Function

Runs an executable program and returns a Variant (Double) representing
the program's task ID if successful, otherwise it returns zero.

Syntax

Shell(pathname[,windowstyle])
 
Back
Top