how to start vba-procedure from macro

  • Thread starter Thread starter Bart
  • Start date Start date
B

Bart

Hi,

i defined following procedure in 'module1' (Access 2007):
Public Sub maproc()
Shell "Notepad.exe"
End Sub

Now i want to start it from a macro. in column 'Action', i took
'ExecuteProcedure' (translated); in column 'Arguments' (also translated), i
put: maproc, then: [module1]!maproc, but i always get the error "can not
find the name maproc ...'.

How can i start that procedure from a macro?
Thanks
Bart
 
i found it:

Sub maproc()
Shell "Notepad.exe"
End Sub

Function callsub()
maproc
End Function

macro: action: RunCode - arguments: maproc()
 
Back
Top