vdennis
Member
I am trying to copy an excel sheet in a workbook and then rename it. I recorded the excel macro which is what I usually do and can usually slug my way until I can get it to work. But what is happening is that a new 'book1' is also being created with the copy command. So I was wondering it anyone had any experience along this line and get me some pointers?
This code to copy is as follows (understanding all the other handles have been called.)
Procedure NewTabCreate:
Message
"Ok, going to copy a sheet"
view-as alert-box.
hWorkSheet:select.
hWorkSheet:copy:sheets:item(1).
end procedure.
Thanks for looking at this.
-Dennis-
This code to copy is as follows (understanding all the other handles have been called.)
Procedure NewTabCreate:
Message
"Ok, going to copy a sheet"
view-as alert-box.
hWorkSheet:select.
hWorkSheet:copy:sheets:item(1).
end procedure.
Thanks for looking at this.
-Dennis-