External program call from Excel VBA

[lars_bentzen]

Hi there,

I am working with large set of data there are extracted and created by
SAS. But the final calculations are made in Excel.

Is it possible to call and execute the SAS-file by VBA code? If so, a
few hints would be appreciated very much.

Thank you in Advance!

Regards,
Lars

 

[Michael Bednarek]

I am working with large set of data there are extracted and created by
SAS. But the final calculations are made in Excel.

Is it possible to call and execute the SAS-file by VBA code? If so, a
few hints would be appreciated very much.

The Shell() function can be used to run external programs; however, it
will execute asynchronously. For your purpose, search the web for
ShellWait() or ShellAndWait(). Here's the one I used i.a. to unzip files
from with Excel's VBA: <http://www.mvps.org/access/api/api0004.htm>.