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



Posted by Juan Pablo on November 09, 2001 7:38 AM

Use the method (Don't recall the exact parameters)

ThisWorkbook.SaveCopyAs Name:=Range("A1")

This will mantain the original book opened, but still create a copy.

Juan Pablo