specify file format, and close the new file and still show the master workbook) - then you would need to do a SaveAs, re-open the master workbook, and close the newly saved-as file. If you want the best of both worlds - i.e. You can then choose to close the master workbook, but have the option not to. If you use SaveCopy As, then the new file is saved in its location (in the same file format), and the master workbook is still shown to the user. If you use SaveAs, then the "master" workbook is essentially closed, and the new file is in front of the user. I think it depends on how exactly you want to structure your workflow, and what you want the experience to be like for the end user.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |