This is probably as close to "Save As" as you can get.
Set oFSO = CreateObject("Scripting.FileSystemObject")
Set oShell = CreateObject("Shell.Application")
Path = oShell.BrowseForFolder(0,"Choose Folder",0,17).Items.Item.Path
Name = InputBox("Please Enter A FileName",,"FileName.txt")
If Path...