How do I rename a sheet?

[gshock]

I want my code to rename the active sheet to "Sheet1".

Neither one of these codes seems to work.

Please Login or Register  to view this content.

Or

Please Login or Register  to view this content.

I don't understand why this doesn't work. Any thoughts?

Thanks,

-gshock

[Leith Ross]

Hello gshock,

Here is an example of renaming a sheet called "Quarterly Report" to "Sheet1".

Please Login or Register  to view this content.

Sincerely,
Leith Ross

[gshock]

Hello gshock,

Here is an example of renaming a sheet called "Quarterly Report" to "Sheet1".

Please Login or Register  to view this content.

Sincerely,
Leith Ross

Hi Leith,
How do I make that work for any sheet name? Each file that is opened will have a different sheet name. So I want to write the code so that it will take a sheet with "any" name, and rename it to "Sheet1". Thanks for the help.


-gshock

[Leith Ross]

Hello gshock,

Can you walk me through the steps you're using? Are these files single sheet workbooks?

Thanks,
Leith Ross

[gshock]

Hello gshock,

Can you walk me through the steps you're using? Are these files single sheet workbooks?

Thanks,
Leith Ross

Hi Leith,
Yes, I'd be happy to walk you through it. The user is going to open a (*.out) file. I want the macro to rename the sheet (single sheet workbook) to "Sheet1", and then save the file as a *.xls file type. Here's my code:

Please Login or Register  to view this content.

Thanks for the help.

-gshock

[gshock]

Hello gshock,

Can you walk me through the steps you're using? Are these files single sheet workbooks?

Thanks,
Leith Ross

Leith,

I figured it out. Here's what I had:

Please Login or Register  to view this content.

Here's what worked:

Please Login or Register  to view this content.

[Leith Ross]

Hello gshock,

Good job! Feels good when you can figure it out.

Sincerely,
Leith Ross