Firing Excel Macro on Export

E

Edgar Thoemmes

I am using the following code to transfer a query to Excel.

DoCmd.TransferSpreadsheet acExport, , "qryContractFilter", "F:\Contract
Database\" & fname, True

Is it possible to fire a macro stored in my Personel File every this query
is exported or is it possible to export the query to an existing file?

I am using Access 97.

Thanks
 
Top