Hello All

I am trying to figure out how to create a macro in Excel to run a macro
named "macro 1" in access (which is a combination of a delete query and
an append query). This will bring up screens that ask questions such
as "are you sure you want to delete xxx records'". They are typically
yes, no or cancel questions. I need to have the macro i create in
excel, run the macro in access, click yes to all of the questions that
come up and then refresh the external datalink in the excel workbook.

Can anyone help point me int he right direction to get something like
this done

Thanks

Cory