External program call from Excel VBA

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

lars_bentzen@hotmail.com - 26 Jan 2007 08:36 GMT

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

Reply to this Message

Michael Bednarek - 26 Jan 2007 13:34 GMT

On 26 Jan 2007 00:36:19 -0800, lars_bentzen@... wrote in
microsoft.public.word.programming:

>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>.

Signature

Michael Bednarek http://mbednarek.com/ "POST NO BILLS"

Reply to this Message