how to start vba-procedure from macro

[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

 

[Bart]

i found it:

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

Function callsub()
maproc
End Function

macro: action: RunCode - arguments: maproc()

 

[Daniel Pineault]

Use

RunCode as the Action
maproc() as the Function Name Property
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.