Excel VBA and API calls? 1

[ijr]

1)Has the VBA built into excel capacity to make API calls?

2) If yes, is it possible to run a DOS batch file from an Excel VBA call

If yes, how?

I will appreciate all pointers

Thanks in advance
IJR

 

[dsi]

Sure. Do a search for Shell and/or ShellExecute in this forum. There are tons of samples.

 

[ijr]

Thanx dsi

but I am new to the stuff. I did the search. However I guess there is no harm if you cite a short example down here. Sorry boss if this is too much.

respects
IJR

 

[dsi]

Sure, here you go. You can use the help on vbMaximizedFocus to find other window options (vbHide, vbMinimizedFocus...).

Sub RunBatFile()
    Dim ret
    ret = Shell("C:\YourFile.bat", vbMaximizedFocus)
End Sub