Did you look at the GetSaveAsFilename method in the Help file?

"D.Parker" wrote:

I am trying to save a "worksheet" from the active workbook_A into a new
workbook_B, but I am wanting the user to input a filename to give workbook_B.
I'm assuming I have to create a UserForm to grab the input name from the
user.

Worksheets("from workbook_A").Select
Worksheets("LogHistory").SaveAs = "c:\temp\<filename from UserForm"

No success. Can anyone prescribe a remedy that is simple? Thank you.

D. Parker