Philip has attended:
Excel Advanced course
Excel VBA Intro Intermediate course
Excel VBA Intro Intermediate course
Advanced Excel
Can i export macros to MS access??
RE: Advanced Excel
Hi Philip,
Thank you for your question;
In answer:
Short answer Philip, No If you are talking about recorded Macros, however using DDE (Dynamic Data Exchange) it should be possible; I have found an example of running an Access Macro in Excel, the reverse you may be able to find on the web
Sub Run_Access_Macro()
'Opens Microsoft Access and the file nwind.mdb
Shell("c:\access\msaccess.exe c:\access\sampapps\nwind.mdb")
'Initiates a DDE channel to Microsoft Access
Chan = DDEInitiate("MSACCESS", "system")
'Activates Microsoft Access
Application.ActivateMicrosoftApp xlMicrosoftAccess
'Runs the macro "Sample AutoExec" from the NWIND.MDB file
Application.DDEExecute Chan, "Sample AutoExec"
'Terminates the DDE channel
Application.DDETerminate Chan
End Sub
I hope that has helped (even if just a bit)