Running Excel macro from access

[king_jonathan]

I need to make a switchboard button which will run an Access macro, open an Excel file and then run a macro in the Excel workbook.

I can open an excel workbook in an Access module, and do all the other bits, but I don't know how to run the excel macro.

Is there any way of doing this?? (i'm sure there is)

could somebody please tell me the code?

Thanks a lot

 

[Fuga]

This works for me.

Dim excelapp As excel.Application


Set excelapp = CreateObject("excel.application")
excelapp.Workbooks.Open ("c:\dir\file.xls")
excelapp.Run ("macroname")
excelapp.Quit

Fuga.