Does anyone know how to call an Excel macro from an Access VBA module I am connecting to Excel using the Excel Automation object but cannot seem to access anything but the assigned startup excel macros.
Any help would be apprecited.
Call Excel macro from Access
Hot Topic
Microsoft ISV
- Personal.xls
- Visio VBA Macro to detect connector endpoints
- How to adress a single cell in a named area
- Help with Excel VBA Code
- How to use data from inputbox
- asp .Net 2.0 --> The specified module could not be found. (Exception from HRESULT: 0x8007007E)
- Ms Access to SQL server Through ODBC
- Count and display in cell
- Size Form to fit user resolution
- Runtime Error 1004, Worksheets method error
Call Excel macro from Access
cyberjoe2
Jody –
If you’re massaging data in Access only, my approach would be to export the macro from Excel and import it to Access.
That’s the simplest case. If you’re trying something else, please elaborate.