Renaming the active workbook

[Legacy 96851]

Is there a way to use VBA to rename the currently open, active workbook? ActiveWorkbook.Name = "Etc.xls" doesn't work, Name being a read-only property.

That is to say, is there a way to do it without using save as to save it to the same directory under a different name.

Edit: oh also, this is completely unrelated, but not worth it's own thread. Is there a way to block comment in VBA without putting an apostrophe before every line?

 

[Norie]

Short answer - no.

 

[schielrn]

For your edit question, select the block of code and go to the edit toolbar and there is a button to comment block of code.

Hope that helps.

 

[VoG]

Edit: oh also, this is completely unrelated, but not worth it's own thread. Is there a way to block comment in VBA without putting an apostrophe before every line?

View > Toolbars > Edit. You can then select multiple lines of code and click the Comment Block button.

 

[Norie]

If you have the edit toolbar displayed there is a button to comment blocks of code and one to uncomment.

 

[Legacy 96851]

Sigh. I never check View, and it's always there. Thanks.

As for the main question, the more I think about it, the less possible it seems. Excel can't even do that without the macro context. Fine with me, these users can just deal with manually changing the name. I've already saved them days of work.