Running an Excel macro from Access

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
Back
Top