JumboCactuar
Well-known Member
- Joined
- Nov 16, 2016
- Messages
- 785
- Office Version
- 365
- Platform
- Windows
Hi,
Sorry if this is not much to go on but im wanting to save workbook by vba to a set directory (directory in cell)
Example (Sheet1):
A1 = c:\temp\reports\
B1 = 24-03-2017
I would like it saved in the above directory with filename:
Report_24-03-2017.xlsm
Also is it possible, to clear 2 worksheets of the new file? To get its size low as possible
Is all this possible from a macro?
Thanks for any help
Sorry if this is not much to go on but im wanting to save workbook by vba to a set directory (directory in cell)
Example (Sheet1):
A1 = c:\temp\reports\
B1 = 24-03-2017
I would like it saved in the above directory with filename:
Report_24-03-2017.xlsm
Also is it possible, to clear 2 worksheets of the new file? To get its size low as possible
Is all this possible from a macro?
Thanks for any help