|
-
Feb 27th, 2014, 01:17 PM
#1
Thread Starter
Hyperactive Member
Is it possible to start an Access macro from Excel using an ADODB.connection?
From Excel 2007, I'm connected to an Access database via ADODB.Connection. From here, I've retrieved some data from the database into a worksheet. Now I'd like to issue a command to the database to start one if its macros. This macro calls a function that is a VBA module. Can this be done? I know I can issue a DoCmd if I do a 'CreateObject("Access.Application") and a 'OpenCurrentDatabase', but I'm already connected.
Thanks.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|