View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] pierrerama@keromail.com is offline
external usenet poster
 
Posts: 2
Default OLE Commands to Duplicate a Sheet

Hi, I would like to know how duplicate a Sheet in excel.

I know only how create a new sheet : xExcelSheetsAdd()

I tried to copy the sheet, create a new sheet, and paste, but it
doesn't work, because Excel display a prompt.
Excel ask if I want to save my copy in clipboard , because the copy is
too important.


Could anyone help me with the correct OLE commands to duplicate a
sheet? An
example program would be great if anyone has one.

Many thanks,

Pierre