I have seen numerous posts of this done but I keep running into the error Method 'Run' of object '_Application' failed. The code in access just has the following:
Public Sub TestMacro()
Then in excel I use the following:
Public Sub TrackerAutomation()...