200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Hi
Presently I am working with a .xlsm file where one PRINT, REFRESH and SAVE AS button are required. However, the PRINT and REFRESH buttons are working properly. But I am unable to write the code for the SAVE AS tab.
If you kindly help me with the VBA code so that the file is saved in a distinct file of a local drive. Also required that a dialogue box will appear each time to incorporate the file name while saving.
Thank you for your time and consideration
Regards
S Chowdhury
You just need to use this line:
fileSaveName = Application.GetSaveAsFilenameThen the user will select a file and the full path and name will be in the fileSaveName variable and you can then use the SaveAs method on it.
Example to save the current workbook:
ThisWorkbook.SaveAs Filename:=fileSaveName