Problems exporting to exel

[lamaar]

I run a macro to export the data in a query to exel.  I use the Macro TransferDatabase.  It used to work fine but now has stopped working.  When i select it, it no longer runs the query.  Any ideas why?

 

[elizabeth]

Access can autoconvert your macros to VBA code. When you run things in code, you have dubugging tools, the capability for error handling, and, <i>sometimes</i> useful error messages.. If you want to try converting your macro to a function and running it that way, just Use File/Save As/Module, etc.