| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Running A Access Macro From Excel
Please can someone help? I have a Macro in Access But I need to run it from
within Excel using VBA code. Is this possible? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Running A Access Macro From Excel
Hello Frank
Yes this is possible using OLE: Requires a reference to Microsoft Access n.0 Object Library where n is version number of Access Dim ObjAcc As Access.Application Set ObjAcc = CreateObject("Access.Application") ObjAcc.OpenCurrentDatabase "D:\Mes Documents\Pascal\Office\Access\DonneesNew.mdb" ObjAcc.UserControl = True AppActivate "Microsoft Access" ObjAcc.Run ("MacroName") Set ObjAcc = Nothing HTH Cordially Pascal "Frank" a écrit dans le message de ... Please can someone help? I have a Macro in Access But I need to run it from within Excel using VBA code. Is this possible? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Running A Access Macro From Excel
ActiveX component can't create object? is there another way of doing this.
Frank "papou" wrote: Hello Frank Yes this is possible using OLE: Requires a reference to Microsoft Access n.0 Object Library where n is version number of Access Dim ObjAcc As Access.Application Set ObjAcc = CreateObject("Access.Application") ObjAcc.OpenCurrentDatabase "D:\Mes Documents\Pascal\Office\Access\DonneesNew.mdb" ObjAcc.UserControl = True AppActivate "Microsoft Access" ObjAcc.Run ("MacroName") Set ObjAcc = Nothing HTH Cordially Pascal "Frank" a écrit dans le message de ... Please can someone help? I have a Macro in Access But I need to run it from within Excel using VBA code. Is this possible? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Running Access-to-Excel Automation.... | Excel Discussion (Misc queries) | |||
| Running Macros in Access from Excel | Excel Programming | |||
| Running Access MAcros or VB modules in Excel | Excel Programming | |||
| "Programmatic Access to be Denied" displays when running macro on excel in XP | Excel Programming | |||
| Launch Macro in Access via Macro running in Excel??? | Excel Programming | |||
Linear Mode
