Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Call an Access macro from an Excel macro
I have a macro in an Access database that I would like to call in a macro I'm
creating for excel. How do I do that? And is it possible to do without opening Access? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Call an Access macro from an Excel macro
Hi Jason,
I don't believe you can call it without opening Access although you can open an instance of Access from Excel with displaying it. It is possible to write code in Excel the manipulates Access using its object model. I believe, to do that you will need to reference its library in Excel and to do that in the VBE you would choose Tools, References, and check Microsoft Access X library. You might also post to the Access Database newsgroup. -- Cheers, Shane Devenshire Microsoft Excel MVP "Jason W" wrote: I have a macro in an Access database that I would like to call in a macro I'm creating for excel. How do I do that? And is it possible to do without opening Access? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro in excel to call a access module to run. | Excel Discussion (Misc queries) | |||
How can I call My Computer through an Excel macro? | Excel Discussion (Misc queries) | |||
Excel vba to call Access Macro | Excel Worksheet Functions | |||
Excel vba to call Access Macro | Excel Discussion (Misc queries) | |||
Using PowerPoint to Call Excel/Macro? | Excel Discussion (Misc queries) |