Change Excel sheet name in Access VBA

[LB79]

Hi all,

Please can anyone tell me if there is a way to change the sheet name of an Excel file that I am exporting from Access (using VBA).

Thanks

 

[DCrake]

Try

    Sheets("Sheet1").Select
    Sheets("Sheet1").Name = "fred"

 

[LB79]

Hi DCrake - Happy new year!
Thanks for the reply but Im not sure how to incorporate that into my Access VBA.
Currently Im exporting to Excel using DoCmd.TransferSpreadsheet which automatically names the Excel sheet the same as the query.

 

[DCrake]

You may have to look at either populating an existing workbook or opening the workbook blindly and renaming the sheet or rename your query the name of the worksheet you want.

 

[LB79]

Ahh OK - Thank you