Forum home » Delegate support and help forum » Microsoft Excel Training and help » Advanced Excel
|
|
|
The UK's most regular 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. |
Advanced Excel
Resolved · Low Priority · Version 2003
Reply Fri 24 Oct 2008, 15:56Delegate Philip said...
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??
For upcoming training course dates see: Pricing & availability
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.
|