•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Any idea why defining my SaveAs Filename:= in VBA isn't populating the file name field in the Save As dialogue box?
I've got a report that runs weekly, and I'm working on putting in a button that the user can click that will do a sanpshot -- SaveAs in the correct place on sharepoint, then delete the data connections. I've done this before and it worked to put the path in, but it's not populating the name and I feel like it should.
savepath = "https://myorganization.sharepoint.com/myintranet/Development/Development Services/Reporting/Weekly Gift Reporting/Weekly Gift Report Archive/" SaveInfo = Application.GetSaveAsFilename(InitialFileName:=savepath & _ "Weekly Gift Report " & _ Format(Range("StartDate"), "yyyy.mm.dd") & "-" & _ Format(Range("EndDate"), "yyyy.mm.dd"), _ filefilter:="Excel Macro-Enabled Workbook(*.xlsm), .xlsm") wkb.SaveAs Filename:=SaveInfo, FileFormat:=xlOpenXMLWorkbookMacroEnabled The SaveAs dialogue box opens up to the correct folder but the filename field isn't populated with "Weekly Gift Report 2026.02.16 - 2026.02.22.xlsm" like I feel like it should be. Any idea why??
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#rows.com
#Excel compatibility
#big data management in spreadsheets
#generative AI for data analysis
#conversational data analysis
#real-time data collaboration
#financial modeling with spreadsheets
#intelligent data visualization
#no-code spreadsheet solutions
#SaveAs
#VBA
#filename
#sharepoint
#GetSaveAsFilename
#savepath
#wkb.SaveAs
#weekly report
#Excel Macro-Enabled Workbook
#filefilter