SUBHAS1812
New Member
- Joined
- Jul 15, 2020
- Messages
- 2
- Office Version
- 2007
- Platform
- Windows
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 properly functioning. But I am unable to write the code / VBA syntax for the SAVE AS option
If you kindly help me with the VBA code so that the file is saved in a distinct file within a specified folder of a local drive. In this process, a dialogue box is supposed to appear each time to incorporate the file name while saving it in a specific folder of a local drive.
Thank you for any ideas or code syntax you might suggest, and let me know if there are any details I have left out that you need to respond.
Subhashis
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 properly functioning. But I am unable to write the code / VBA syntax for the SAVE AS option
If you kindly help me with the VBA code so that the file is saved in a distinct file within a specified folder of a local drive. In this process, a dialogue box is supposed to appear each time to incorporate the file name while saving it in a specific folder of a local drive.
Thank you for any ideas or code syntax you might suggest, and let me know if there are any details I have left out that you need to respond.
Subhashis