Running an Excel macro from Access

G

Guest

I have a situation where I need to 1) open a specific workbook from Access 2)
run a macro in the workbook; all from an Access form. Ideally I would like
to create a button that, when clicked, will open the workbook, run the macro,
then close the workbook. Two sheets in the workbook will be linked tables in
the access database. Can anyone help me?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Running excel macro from an Access Macro 3
Excel Protection 2
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Excel shortcut options 0
Run Excel Macro from Access 2
Working with Excel and Access VB coding? 4
Excel/Access 2
Running Excel Macros from a different Spreadsheet 1

Top