S
Simon Jelinek
I am trying to create macro i want to export several
queries to one excel file. In the macro you can select the
OutputTo
Object type : Query
Object name : Qry 1
Output format: Microsoft Excel (*.xls)
Output File : PAth1\path2\path3\file name
under the macro i would like to select another query with
the dat1 to be exported into the same file but not over
the top and not as seprate file. The ability to select a
specific sheet would be useful.
Thanks in advance
queries to one excel file. In the macro you can select the
OutputTo
Object type : Query
Object name : Qry 1
Output format: Microsoft Excel (*.xls)
Output File : PAth1\path2\path3\file name
under the macro i would like to select another query with
the dat1 to be exported into the same file but not over
the top and not as seprate file. The ability to select a
specific sheet would be useful.
Thanks in advance