"Copy and Paste Worksheet Range" Action in MS Excel VBO

[Anonymous]

Hi all, Just wondering if anyone has had any experience using this action in the MS Excel VBO. There is no specific instructions of it's use in the documentation, and it looks as if it may be missing an input (handle of destination workbook?) Has anyone ever used this action, because I can't seem to get it to work based on how it is setup. Any thoughts? Thanks

[RadoslavHiko]

You can only use it within the same instance of Excel, i.e. you only need one handle. In other words, you must open all workbooks you want to copy from and to in the same instance.

[Anonymous]

What he said is correct?  I have used it.  Create Instance - Open Workbook 1, Open Workbook 2, Determine Copy Range, Copy and Paste Worksheet Range, Save Current Workbook As.