Copy Accessdata into Excel tabs

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

Thankyou !

[ItsMe]

You will need to reference the Microsoft Excel XX.0 Object Library. Then, you would begin by using code similar to this.

Dim xlApp As New Excel.Application
Dim myBook As Workbook
Dim mySheet As Worksheet
Dim myShape As Shape
 
Set myBook = xlApp.Workbooks.Add
Set mySheet = myBook.Worksheets(1)
mySheet.Name = "SheetName"

[baba]

Thank you so much referencing to Excel is the key