Call an Access Macro?

Dexter1 · Post by **Dexter1** » Wed Dec 05, 2007 7:00 pm

I'm trying to open an MS Access database then call a specific macro. I thought I could do it in by using VB within the MacroScheduler macro, but can't seem to get it rolling. Here's the code. At this point I'm just trying to get Access to open:

VBStart
Function Open_MSAccess()
Call Shell ("C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE")
End Function

As always, thanks in advance for any help you can give me.
Josh

Post by **Marcus Tettmar** » Wed Dec 05, 2007 7:21 pm

Hi,

Your macro is trying to open Excel, not Access. Did you mean Access or Excel? Your macro is also using VB code which is not valid VBScript code.

Anyway, if you DID mean Access, here's the solution you are looking for:

http://www.mjtnet.com/forum/viewtopic.php?=&p=15358

If you meant Excel, the above link shows you that too

Dexter1 · Post by **Dexter1** » Wed Dec 05, 2007 7:49 pm

Ah, yes, I did mean Access. I don't know how I ended up with Excel in there.

Thanks!