advanced excel

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Advanced Excel

Advanced Excel

resolvedResolved · 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.


 

Excel tip:

Adding Rows or Columns in an Excel 2010 Worksheet

If you want to add a row to an Excel spreadsheet, these are the simple steps you should take:

With your mouse, right click on the row header below where you want the new row to be added. Then, click Insert.

Follow exactly the same steps if you want to add a column to an Excel worksheet, right click on the column header, choose Insert and the new column will be inserted to the left of the selected column.

View all Excel hints and tips


Server loaded in 0.07 secs.