Zack Barresse
MrExcel MVP
- Joined
- Dec 9, 2003
- Messages
- 10,881
- Office Version
- 365
- 2010
- Platform
- Windows
- Mobile
- Web
is there a way to write code that will create a new file (i've got that), and save the new file as a specified file name - but, if that name already exists, will change the name (i.e. name, name1, name2, name3...) if it already exists?
i'm not having luck finding this in help resources.
oh, and one other (sorry about doubling up here)
i have code which will close the original book
Windows("Day_Report 4 Opacity 2003").Activate
ActiveWindow.Close
it always asks me if i want to save before closing (in lieu of changes, of course) and i never ever want to save. is there a way to bypass this?
i'm not having luck finding this in help resources.
oh, and one other (sorry about doubling up here)
i have code which will close the original book
Windows("Day_Report 4 Opacity 2003").Activate
ActiveWindow.Close
it always asks me if i want to save before closing (in lieu of changes, of course) and i never ever want to save. is there a way to bypass this?