Running an app from a form

[judyscofield]

I have a compiled c++ program that I would like to run from a form. When I run the exe, it asks for four inputs and produces a file. When I try to run it from Access, the program starts, asks for the for inputs and closes, but the file doesn't get produced. In the event code of the button on the form I have
Dim stAppName As String

stAppName = "c:\afcars\chkdat3.exe"
Call Shell(stAppName, 1)

What am I doing wrong?

Judy Scofield

 

[eussias]

Judy,

Try this....

dim objWord as Object
dim strFilename as String

strFilename = "c:\afcars\chkdat3.exe"
Set objWord = GetObject(strFileName)
objWord.Application.Visible = True

Hope it helps....

 

[judyscofield]

Thanks, I tried this and got
Filename or class name not found furing Automation operation

on the Set objWord statement

??

Judy

 

[Haitham]

Why not save headeach and do it in one line,
ver = Shell("Your Application Location&quot
That's it

Good Luck

 

[Haitham]

Sorry,

var = Shell("Your Application Location&quot

Good Luck