98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Advanced Excel
Advanced Excel
Resolved · Low Priority · Version 2003
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)
Mon 22 Dec 2008: Automatically marked as resolved.
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Adding Rows or Columns in an Excel 2010 WorksheetIf you want to add a row to an Excel spreadsheet, these are the simple steps you should take: |