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

[J_Orrell]

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]

....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:-

http://www.niftyaccess.com/update-excel-ms-access/


Sent from my SM-G925F using Tapatalk

 

[Gasman]

Another method is here
https://social.msdn.microsoft.com/F...-to-specific-excel-worksheets?forum=accessdev

 

[J_Orrell]

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

 

[arnelgp]

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.