Export an Access query to an existing Excel spreadsheet in VBA (1 Viewer)

Guys. quick question. I know how to export an Access query to a new Excel spreadsheet using the DoCmd.TransferSpreadsheet method, but is there a way to make a new tab in an existing spreadsheet and export it to that?

If not, then my users are just going to have to put up with copying data from a second spreadsheet and pasting into a new tab in the first. So it's not a huge drama but it would be a great nice-to-have.

Uncle Gizmo

Nifty Access Guy

Staff member Local time Today, 14:48 Joined Jul 9, 2003 Messages 16,679 . is there a way to make a new tab in an existing spreadsheet and export it to that.
.

When I want to do some fancy stuff with Excel I usually start with these two links on my website here:-

Sent from my SM-G925F using Tapatalk

Gasman

Enthusiastic Amateur

Local time Today, 14:48 Joined Sep 21, 2011 Messages 15,294

J_Orrell

Registered User.

Local time Today, 14:48 Joined May 17, 2004 Messages 55

Thanks for your help guys, I'm sure I can cobble together a solution that works best for me from your suggestions.

arnelgp

..forever waiting. waiting for jellybean!

Local time Today, 21:48 Joined May 7, 2009 Messages 19,449

Just makeif you use Same query name it will be copied on same sheet. Create new query or copy existing query to diff name. Use the new query name to transfer to same excel workbook.