Auto Rename Worksheet Before Closing

[sandiptemkar]

Hello All,

I need a VBA which will rename my existing excel workbook based on cell value/text; however this should be done automatically (macro should automatically run before closing the excel sheet).

Also note I need to save the current excel workbook on same path but just with different name so i does not need multiple workbooks.

Can this be done?

Sandeep

[venkat1926]

in your file (excel 2007)
click developer
click vbeditor (lefternmost)
hit control+R
all open filed will be listed
go to your file
select "thisworkbook"
right and click view code
in the window that opens copy this EVENT CODE and save the file

Please Login or Register  to view this content.

this will save the file in the same folder of this workbook with the name given by you

[HaHoBe]

Hi, venkat1926,

this will save the file in the same folder of this workbook with the name given by you

I doubt no as you should use a different variable for the string as path which is a VBA Keyword. A trailing s indicates a collection while the normal would be String. Last: ThisWorkbook.Path holds the path excluding the final pathseparator.

Please Login or Register  to view this content.

Ciao,
Holger

[sandiptemkar]

Hello Both,

Thank you so much! It worked!

Hahobe: your trick of saving file with date and time is simply awesome, added reputation!