Edit excel workbook from Access

[polina]

Hi,

I wonder if anyone could show me how to rename the several worksheets within one excel workbook that I access from within the Access module.

What I do is I let user choose a excel file, then create Excel object

Dim xls As Excel.Workbook
Dim wks As Excel.Worksheet

Set xls = Workbooks.Open("C:\File.xls")
Set wks = xls.Worksheets

The excel file has many sheets in it. I want to be able access each and rename it. I also want to edit the data type format in every sheet.

Please advise.
Any hints would be greatly appreciated.

Thanks.