shapeshiftingkiwi
New Member
- Joined
- Mar 31, 2021
- Messages
- 33
- Office Version
- 365
- Platform
- Windows
I'm trying to create a save as button in excel and adapted the below code from a video guide. However whenever I click on the button or hit the code to run, nothing happens. The macro is linked to the button and the button does "depress" to show it was clicked. What am I missing?
Sub Save_As()
With Application.FileDialog(msoFileDialogSaveAs)
.Title = "Save"
.ButtonName = "Save Form"
.InitialFileName = "C:\Users\MYNAME\OneDrive - MY COMPANY\Documents\Excel\" & Range("M3").Value
End With
End Sub
Sub Save_As()
With Application.FileDialog(msoFileDialogSaveAs)
.Title = "Save"
.ButtonName = "Save Form"
.InitialFileName = "C:\Users\MYNAME\OneDrive - MY COMPANY\Documents\Excel\" & Range("M3").Value
End With
End Sub