Create new workbook, save using input box

[Sphinx404]

I've read a lot of the different threads on this forum concerning adding a new workbook but I cannot seem to get the macro to work the way it needs to... the code below doesn't work, it's not the proper syntax but it gives you an idea of what I'm trying to do:

1. add new Workbook
2. save new Workbook
3. add input box so the user can designate the filename
4. designate the proper filepath
5. save file to filepath

[COLOR=#323232][FONT=Arial]Sub Macro2()[/FONT][/COLOR]
[COLOR=#323232][FONT=Arial]Dim Wk As Workbook
Dim fname As String[/FONT][/COLOR]
[COLOR=#323232][FONT=Arial]Set Wk = Workbooks.Add
Application.DisplayAlerts = False
fname = InputBox(“What is the filename?”)
Wk.SaveAs Filename:=”C:\” & fname & “.xlsx”
Application.DisplayAlerts = True[/FONT][/COLOR]
[COLOR=#323232][FONT=Arial]End Sub[/FONT][/COLOR]

It seems like a simple task, if anyone could offer their guidance I'd be appreciative. Thanks!

 

[JLGWhiz]

Why not use the SaveAs dialog box? That way you can select the path with the dialog box tools as well as enter the name and file extension you want.

Sub Macro2()
Dim Wk As Workbook
Dim fname As String, fPathFile As String
fname = InputBox("Enter the file name to use, including file extension.")
Set Wk = Workbooks.Add
fPathFile = Application.GetSaveAsFilename(fname, "Excel Files (*.xlsx), *.xlsx")
wk.SaveAs fPathFile
End Sub

 

[Sphinx404]

Why not use the SaveAs dialog box? That way you can select the path with the dialog box tools as well as enter the name and file extension you want.

Sub Macro2()
Dim Wk As Workbook
Dim fname As String, fPathFile As String
fname = InputBox("Enter the file name to use, including file extension.")
Set Wk = Workbooks.Add
fPathFile = Application.GetSaveAsFilename(fname, "Excel Files (*.xlsx), *.xlsx")
wk.SaveAs fPathFile
End Sub

Thank you! I decided to give the user the option to select their own filepath rather than designate one, but this gave me the bits and pieces I needed to complete the code. Thanks for your assistance!

 

[JLGWhiz]

Thank you! I decided to give the user the option to select their own filepath rather than designate one, but this gave me the bits and pieces I needed to complete the code. Thanks for your assistance!

You're welcome,
regards, JLG