URGENT - How do I save a workbook and make a duplicate using a name from a cell in first workbook?
Posted by BeverleyB on November 09, 2001 7:24 AM
Hello to all experts!!
I have an input box which pops up when I open my workbook where you would enter a name to be placed in a cell, I want that when the user exits the form that the workbook is saved and a duplicate workbook is created somewhere with the name in cell , WITHOUT THE USERS KNOWLEDGE. I have the part where it is saved as the name in a cell working to some extent, but when the workbook is saved as the new name the workbook I started with is not saved. Any Suggestions would be appreciated.
Thanks
Bev