john3j
10-13-2009, 05:25 AM
Hey guys,
Is there a way to run an access macro from excel. Lets say I have test1.mdb located at R:\Test and I want to run the macro called "autoexec". I do not want access to stay open after this. The point of doing this is so that I can have access prepare my tables for me, then using a dashboard made in excel to open excel sheets that depend on these tables. If anyone could provide me with a module or something to achieve this, it would be greatly appreciated. Thanks!
Is there a way to run an access macro from excel. Lets say I have test1.mdb located at R:\Test and I want to run the macro called "autoexec". I do not want access to stay open after this. The point of doing this is so that I can have access prepare my tables for me, then using a dashboard made in excel to open excel sheets that depend on these tables. If anyone could provide me with a module or something to achieve this, it would be greatly appreciated. Thanks!