Hemant,
Thank you for the response. I don't want to save the worksheet with
all of the underlying code. There is a lot of code that becomes
unnecessary once the worksheet has been created and saved. The
original workbook acts as a switchboard for creating new and
searching, opening, and closing p
Why dont you include the original vb code in the new workbook?
use
application.savecopyas("\\path\name.xls")
Or
if you are anyway closing the original workbook
'delete unwanted sheets and save
applcation.displayalerts=false
sheets("unwanted1").delete
sheets("unwanted2").delete
thisworkbook.sav
