Run macro via /x
Posted on 2009-04-02
I'm using access 2003.
I'm using the following code to open my database and after that I'll try to automatically run a macro called test;
Dim WshShell, oExec
Set WshShell = CreateObject("WScript.Shell")
sCmd = Chr(34) & "C:\Program Files\Microsoft Office\Office12\MSACCESS.EXE" & Chr(34) & " " & Chr(34) & "C:\Users\paul tikken\WordMerge2008.mdb" & Chr(34) & _
" /wrkgrp " & Chr(34) & "C:\Users\paul tikken\Beveiliging.mdw" & Chr(34) & " /user administrator /pwd ******* /X test"
Set oExec = WshShell.Exec(sCmd)
Access will open as it should but when it comes to the macro access tells me that it cannot find the test macro. I've checked the spelling several times, seems to match.
What is the problem?