CopyAccess data into excel template

[baba]

How to open a pre filled excel template in read and write mode from msaccess vba and insert data from msaccess tables
into specific columns in excel.
Rename the tabs in excel sheet based on a specific column in the access data.
Each row in the table will go to a seperate tab in excel.
Save the excel template after populating the necessary data into different tabs.

 

[pbaldy]

You've packed several questions in there, but generally you'll use automation for all of it. The basics:

https://support.microsoft.com/en-us/kb/210288

One trick when learning is to record a macro in Excel doing one step, and the resulting code gives you a step up in Access.

 

[baba]

Thank you for the help

 

[pbaldy]

No problem.