Hi,
I am writing a macro / Com Addin, in which one the
requirement is to duplicate a existing / a open Excel
Workbook. The only thing that i found was the worksheet
copy / move method. Also, in this method the data does not
go to the clipboard, So if i copy something and close
excel and reopen, i will not have anything the clipboard.
Moreover, If I need to copy the whole work book, I need to
copy the sheets one by one. Is there a simpler way to do
this?
(something similar to select all and copy and paste. If we
do this in word, even the header footer and the styles get
copied). For some reasons, I dont want save the
Workbook and copy the file to duplicate the
workbook.

Thanks in advance

Ashok