Hello, I am trying to run a batc

[Liam1]

Hello,

I am trying to run a batch file from Access. I'm not very good at VBA, but what I would like to do is:

Return a code to my Access database when the application closes.
e.g
Shell(File.Bat)
*BTEQ Opens*
*do something for 5 minutes*
*BTEQ Closes
now my bit:
a variable is populated/created upon the called application's closure, that will allow me to trigger another function.

Is this even possible?

Thanks in advance,

Liam1

 

[SkipVought]

Hi,

Have your Batch program create/build/close a log file.

In your loop, test for the existance of the log file. Once the batch program finishes and releases the log file, it will show up.



Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[ETID]

Look at this FAQ

....It's sounds like you need to suspend the code until a shelled process is complete.

 

[ETID]

OOOps...guess you need the faq #

faq707-2542