Hello,
I was looking into how to save a certain sheet to another workbook. I have managed to do that but only if its opened. then I found the code below for when the receiving workbook is closed.
My Question:
is there a way to save to a workbook, being opened or not?
Also I would like to rename automatically the new sheet with the name from a cell. is that possible?
Please Login or Register to view this content.
thank you in advnace,
Luis
Bookmarks