Execute Batch Files with VBA (SOLVED)

[dowingc]

Do you know of a way to have a command button trigger a DOS Batch file? I want a user to click 'Import' and excel will execute a batch file and import a predesignated filename automatically. Thanks!
This message was edited by dowingc on 2002-11-21 03:10

 

[zacemmel]

Try this:

foo = Shell("yourfile.bat")

If this doesn't work, try the API function -- shellexecute

_________________
Questions?<a href=http://www.excelquestions.com>http://www.excelquestions.com</a>
This message was edited by zacemmel on 2002-10-28 23:32

 

[dowingc]

getting an error saying "foo" is not defined. I did a search for the syntax of shellexecute and vba help doesn't come up with anything. :|

 

[dowingc]

Ah, got the shell function working sort of, I can play with it...Thanks!!

 

[zacemmel]

shellexecute isn't an Excel function. It's an API function located in shell32.dll. You need to put this into a module.
Here is the syntax:

Public Declare Function ShellExecute Lib "shell32.dll" Alias "ShellExecuteA" (ByVal hwnd As Long, ByVal lpOperation As String, ByVal lpFile As String, ByVal lpParameters As String, ByVal lpDirectory As String, ByVal nShowCmd As Long) As Long