Advertisement
Guest User

Untitled

a guest
Jul 18th, 2019
87
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.33 KB | None | 0 0
  1. Sub SaveAs()
  2. Dim IntialName As String
  3. Dim sFileSaveName As Variant
  4. IntialName = "Sample Output"
  5. sFileSaveName = Application.GetSaveAsFilename(InitialFileName:=InitialName, fileFilter:="Excel Files (*.xlsm), *.xlsm")
  6.  
  7. If sFileSaveName <> False Then
  8. ActiveWorkbook.SaveAs sFileSaveName
  9. End If
  10. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement