How to save file with copy and paste in a macro

[sb615]

I'm trying to copy part of the text in a document then go to save as and paste that text as the file name. I'm not sure what the correct code is, and if I actually paste then the code just has the text as the file name. Can someone help me out?

 

[ajetrumpet]

I have no idea what you mean, but if you're talking about changing the file name itself upi can use:

ms.saveas "NEWFILENAME"

this will save a brand new book in your default folder though. If you just want to rename the file while it's open, not sure if you can do that.