MS Access: Convert OutputTo macro to VBA code in Access 2003/XP/2000/97

Question:  In Access 2003/XP/2000/97, how can I convert a OutputTo macro to VBA code?

Answer:  We'll demonstrate with the example below.

To convert the macro above to VBA code, you would use the following command:

DoCmd.OutputTo acOutputQuery, "Engineering", acFormatXLS, "test1.xls", False