Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

advanced excel

ResolvedVersion 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 courses

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Excel tip:

Charts

Select the data and press the function key F11 and the chart will be created on a separate worksheet.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.