Using VB to run an Access macro from Excel

[jbird27]

I am an extreme newbie on VB, so I apologize if this seems so simple. I am trying to run a module from an Excel spreadsheet that will open and run an Access macro. I have been able to open the database using the OpenDatabase function, but it then prompts me for which query, table, or form I want opened. Do I need to even open the database in this manner 1st? I just want to run my specified macro from within the Access db. Any suggestions?

[Killer42]

I am an extreme newbie on VB, so I apologize if this seems so simple. I am trying to run a module from an Excel spreadsheet that will open and run an Access macro. I have been able to open the database using the OpenDatabase function, but it then prompts me for which query, table, or form I want opened. Do I need to even open the database in this manner 1st? I just want to run my specified macro from within the Access db. Any suggestions?

Can you show us what code you have so far?