I have managed to get it to open the job by using the following:

RetApp = Shell("C:\Program Files\ShowCase STRATEGY\Bin\vista.exe
E:\excel\projects\AF\007b. Daily CBS Data - CBS New to DMS.dbq")

The first time a job opens it prompts the user for a username and password.
Is there any way to incorporate that into the code?

"fullers" wrote:

I have the following code that works:

Sub Macro1()

RetApp = Shell("C:\Program Files\ShowCase STRATEGY\Bin\vista.exe")

End Sub

This loads Showcase but I then want it to run several queries such as:

E:\excel\projects\AF\007b. Daily CBS Data - CBS New to DMS.dbq

How do I set that up to run once the program has loaded?

Thanks in advance