waiting for shell in VBA

[Gary Roach]

i'm using VBA with access under office XP and i want to execute a shell
function synchronously. i can get the task ID back from the shell call but
what do i do with it? the documentation on shell tells me:

By default, the Shell function runs other programs asynchronously. This
means that a program started with Shell might not finish executing before
the statements following the Shell function are executed.

which suggests that there is a way to override the default asynchronous
behaviour but it doesn't say how. currently i am using doevents but i don't
know if this is reliable. any ideas? your help is greatly appreciated.

gary

 

[Jonathan West]

Hi Gary

Go to http://www.mvps.org/vb/index2.html?samples.htm and scroll down to
Shell32.zip, and download that file.

It includes a module which executes shell programs synchronously. Although
written in and for VB, you can import it into an Office VBA project
unchanged.

 

[Gary Roach]

that's great! thanks for the info

gary

Hi Gary

Go to http://www.mvps.org/vb/index2.html?samples.htm and scroll down to
Shell32.zip, and download that file.

It includes a module which executes shell programs synchronously. Although
written in and for VB, you can import it into an Office VBA project
unchanged.

--
Regards
Jonathan West - Word MVP
http://www.multilinker.com
Please reply to the newsgroup