Hello, been trying to figure this out but can't quite get there.
I have a workbook and I've added a button with the following macro attached:
This works fine, in that it opens the Save as dialog, however, the filename field is blank, and I'd like this to populate the field with the filename "Portfolio Balance Tool.xlsm" - so the user can then change the filename as required.
Also, the file location goes to my documents folder by default, and I'd like it to select the folder of the open workbook.
Any ideas to update my VBA code? Thank you!
I have a workbook and I've added a button with the following macro attached:
VBA Code:
Sub Save_settings_button()
'
' Save_settings_button
'
'
Worksheets(1).Activate
Application.GetSaveAsFilename
End Sub
This works fine, in that it opens the Save as dialog, however, the filename field is blank, and I'd like this to populate the field with the filename "Portfolio Balance Tool.xlsm" - so the user can then change the filename as required.
Also, the file location goes to my documents folder by default, and I'd like it to select the folder of the open workbook.
Any ideas to update my VBA code? Thank you!