A very powerfull tool to work with ActiveX in Microsoft applications is the Record Macro tool.
Try this: Open MS Excel at worksheet you want to copy, go to the menu "Tools" select "Macros" and then "Record New Macro...". Make a copy of the worksheet and every thing you want to do with the workbook and stop recording the macro. Again select "Tools>Macros>Macro..." select the macro you've created and choose to "Edit". The Excel will open the Visual Basic editor and show you the code you've recorded. This code has the same codes you need to implement at your vi activeX Server to execute your job.
If that doesn't work let me know ok?
