I am running a MACRO with the following code in Office 2007 and Vista Enterprise:
SaveFile = Application.GetSaveAsFilename(InitialFileName:=Nme + ", Portfolio Summary Report", _
FileFilter:=Filt, FilterIndex:=1, Title:="Browse to Location for File")
ActiveWorkbook.SaveAs Filename:=SaveFile _
, FileFormat:=51, Password:="", WriteResPassword:="", _
ReadOnlyRecommended:=False, CreateBackup:=False
The save as box does not sisplay the file name "Nme" Instead, the name is blank. I have verified Nma does indeed contain a filename (printed it out), so I'm thinking there is a problem with the function. It used to work prior to some enhancement programming, but not now. Can anyone help?
Bookmarks