Pause macro so CMD can run

[shank]

MS Access 2007 / Win 7
I need to pause a macro until an external command processes. I'm assuming teh macro will then continue when the command finishes. I found the below function on the microsoft site. I get error: Run-time error 53 File Not Found: Kernel and when I opt to debug this line is highlighted: While (GetModuleUsage(hMod)). I know nothing about VB. I googled on that error and not finding anything that helps.

I'm calling the function as RunCode: WaitShell("C:\SSCC Label App\FSSCC.exe")

How do I get this running? Or, if necessary, is there another function available that will stop a macro long enough for a command window to run then continue when it closes?

Option Explicit
Declare Function GetModuleUsage% Lib "Kernel" (ByVal hModule%)
Function WaitShell(AppName As String)
Dim hMod As Integer
hMod = Shell(AppName, 1)
If (Abs(hMod) > 32) Then


While (GetModuleUsage(hMod))
DoEvents
Wend
Else
MsgBox "Unable to start " & AppName
End If
End Function

thanks!

[June7]

Do you have the link to that MS webpage?

What is the external command and how is it initiated?

You reference 'macro' but you show VBA code. Macros and VBA are different things in Access.

[shank]

Link: https://support.microsoft.com/kb/96844/EN-US
Command: C:\SSCC Label App\FSSCC.exe
I'm calling the function as RunCode: WaitShell("C:\SSCC Label App\FSSCC.exe")

[June7]

That code was written for VB, not Access VBA. Sometimes code is adaptable. However, I get the same error message.


I tried Bing: VBA error kernel not found

I tried changing the code to Kernel32 but that also errored. http://computer-programming-forum.co...e8a978826a.htm

Virtually all returns concerned VB. Seems to have something to do with a missing dll (library) file. The one time I tried to download and install a library failed. Damn user permissions on Windows 7 home laptop.

Maybe this will help, all I can give: http://pcsupport.about.com/od/findby...sing-error.htm

[pbaldy]

Is this appropriate?

http://access.mvps.org/access/api/api0004.htm