Creating multiple worksheets in export

  • Thread starter Thread starter Jeremy Ames
  • Start date Start date
J

Jeremy Ames

I need to create multiple worksheets into a single spreadsheet from several
queries. I know that I can export a single worksheet using the OutputTo
function. Any help you can give will be greatly appreciated. I am running
out on a deadline here.

Thanks,

Jeremy Ames
 
Do it through a macro. You can output data to Excel and specify the cell range where you need it to go
Therefor you can specify the first query to go to Worksheet1!A1:E1000 and query two to go to Worksheet1A1001:E2000 for example.Just make sure you leave enough space so that they don't overlap

----- Jeremy Ames wrote: ----

I need to create multiple worksheets into a single spreadsheet from severa
queries. I know that I can export a single worksheet using the OutputT
function. Any help you can give will be greatly appreciated. I am runnin
out on a deadline here

Thanks

Jeremy Ame
 
Would I user the fully qualified name and then the worksheet name? Such as
c:\MyWorkbook.xls!Worksheet1?

xxx said:
Do it through a macro. You can output data to Excel and specify the cell range where you need it to go.
Therefor you can specify the first query to go to Worksheet1!A1:E1000 and
query two to go to Worksheet1A1001:E2000 for example.Just make sure you
leave enough space so that they don't overlap.
 
Yes, and the cellrange you want it to be e.g.
c:\MyWorkbook.xls!Worksheet1!A1:C100

----- Jeremy Ames wrote: ----

Would I user the fully qualified name and then the worksheet name? Such a
c:\MyWorkbook.xls!Worksheet1

xxx said:
Do it through a macro. You can output data to Excel and specify the cel range where you need it to go
Therefor you can specify the first query to go to Worksheet1!A1:E1000 an
query two to go to Worksheet1A1001:E2000 for example.Just make sure yo
leave enough space so that they don't overlap
 
Back
Top