Send Results of Two Queries to One Spreadsheet

R

ryguy7272

I am wondering if there is an easy way to use TransferSpreadsheet in a Macro,
to transfer the results of two queries to a single spreadsheet, appending one
query under the other, in the same spreadsheet.
 
R

ryguy7272

Wow!! I've never used that Union Query before, but I just tried it and it
worked great!! Thanks for pointing me in the right direction Karl!!

Regards,
Ryan---
 
C

Cute Techie

Hi I read your post and your question seems quite interesting. I'm still
learning. Could you explain how this would work. I know how to create
queries, I'm new to the Union query and how it would display.
Thanks for any reply
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

TransferSpreadsheet Macro 1
Email Spreadsheet from Access with multiple tabs 1
Transfer Spreadsheet not starting new Tab 1
Transfer text? 7
cannot expand named range 1
Have a Query Transfer to a Specified Tab in Excel 1
passing params to multiple querydefs and transferspreadsheet 8
NO Transferspreadsheet option in 2007? 1

Top