Hello,
I got that vba code somwhere in the forum after some little amendment I took it into my work
The code does the following
Please Login or Register to view this content.
Based on the checkbox marked it opens that workbook copy Sheet1 and rename the copied worksheet with "NewData".
I want that vba code to close that workbook from where Sheet1 is copied after copying the worksheet.
I want it to check before copying if there is any worksheet named "NewData" in my active(CAPIProjectManagement.xlsm) workbook.If exists then rename the Sheet named "NewData" into "OldData" (And if there is already sheet named "OldData" then delete it) before copying and give the name "NewData" to newly copied worksheet.
I tried to do but I couldn't.
Any help will be appreciated!
Thank you
Bookmarks