I
ITperson
Hello
In Access 2002, I have a macro that runs a query to export the query results
to excel. The Export works, however, In my Excel template (.xlt file), I
have some code that will split the data into sheets and sort the sheets in
Alphabetic order.
In the Macro, I have the Output to option where I indicate where the
template file for excel is. Because I leave the Save file as option blank it
prompts me for a filename; which is fine.
Problem is, is when the macro runs, it creates the workbook and saves it and
opens it but there is none of the code I wrote in the excel template in the
file at all. Infact, there is no "Module1" (which I named the module that
contains the code).
Any suggestions as to what may be happening with my module in excel or even
how to resolve the issue?
Thank you
Terry
In Access 2002, I have a macro that runs a query to export the query results
to excel. The Export works, however, In my Excel template (.xlt file), I
have some code that will split the data into sheets and sort the sheets in
Alphabetic order.
In the Macro, I have the Output to option where I indicate where the
template file for excel is. Because I leave the Save file as option blank it
prompts me for a filename; which is fine.
Problem is, is when the macro runs, it creates the workbook and saves it and
opens it but there is none of the code I wrote in the excel template in the
file at all. Infact, there is no "Module1" (which I named the module that
contains the code).
Any suggestions as to what may be happening with my module in excel or even
how to resolve the issue?
Thank you
Terry