How do you export to separate workbooks in 1 Excel file.

[colezpapa3]

I need to export separate queries to its own workbook contained in 1 excel file. How???

 

[bubba100]

Each Excel file is one workbook. Each workbook can contain one or more worksheets.

Are you asking how to export multi- queries each to different a worksheet in the same workbook?

 

[colezpapa3]

oops. I want each query result to reside in a separate worksheet, ie, I have 3 queries, so I want to export them to 1 workbook file containing 3 worksheets.
I do this manually, but I am building a macro to run each day.

 

[SkipVought]

colezpapa3,

I notice that over the past year, you have posted 37 threads and have received many good tips related to your stated needs. Yet, you have responded NOT ONCE, to
[blue]
Thank Tek-Tip Contributor
for this valuable post![/blue].

The little purple Stars accomplish several important things.

First, it gives positive feedback to contributors, that their posts have been helpful.

Second, it identifies threads as containing helpful posts, so that other members can benefit.

And third, it identifies the original poster (that's YOU, BTW), as a grateful member, that not only receives, but is willing to give tokens of thanks.

Skip,
[sup]Don't let the Diatribe...
talk you to death![/sup][sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[bubba100]

Take a look at the transfer spreadsheet method.

 

[colezpapa3]

I have been very grateful of all the help I have received on the site.