abesimpson
Active Member
- Joined
- May 3, 2003
- Messages
- 435
For a variety of reasons I would like to start Access and various macros from a Visual Basic Script (VBS), or similar.
I have found the following code on the internet, but obviously I can't get it to work
Error:...can't find procedure AO... The macro name is AO, and the access path is correct.
Any suggestions as to how to fix it?
Thanks as always
a
I have found the following code on the internet, but obviously I can't get it to work
Code:
set objaccess = createobject("Access.application")
objaccess.opencurrentdatabase ("E:\AO_VERIFICATION\AO.mdb")
objaccess.run "AO" ' >> Macro name
objaccess.CloseCurrentDatabase
set objaccess=nothing
Error:...can't find procedure AO... The macro name is AO, and the access path is correct.
Any suggestions as to how to fix it?
Thanks as always
a
Last edited: