Same excel file different tabs - Automated Export from Microsoft Access to Excel


	Back to Automated Export Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Same excel file different tabs

Mandy Duncan

2 years ago

Good morning,

Can you export three queries to the same excel workbook that has different tabs named after the queries?

Thanks,

Mandy D

Kevin Yip @Reply

2 years ago

You need to use automation to do this. Automation is a way for Office applications to control one another. With it, you can use VBA code to not only export to specific tabs, but also create an entire Excel workbook from scratch, or a Word doc from scratch automatically, hence the term automation. It is all done with VBA code, which could be complex depending on the complexity of the task. This site has courses on that. I will show you some sample code later.

	Kevin Yip @Reply 2 years ago
The VBA code pictured below copies the data from an Access recordset to a specific Excel worksheet tab and cell.

	Kevin Yip @Reply 2 years ago

	Sami Shamma @Reply 2 years ago
Excel Automation Excel Automation 2 Excel Automation 3

	Mandy Duncan OP @Reply 2 years ago
I'm currently caught up in an endless loop of VBA and SQL videos. I just wanted to say Thank You in case I don't make it back here.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Automated Export.

Next Unseen

New Feature: Comment Live View