rua

Hi all.

I am playing around with Excel in order to learn how COM works.
I am able to open a file, select a range of cells, and copy
these to the clipboard using core OlePropertyGet and
OleProcedure types of functions.

But ho do I select the location where I want to paste the
data?

Selecting the range to be moved:

Row = Wsheet.OlePropertyGet("Range","A1:A4");
Row.OleProcedure("Select");
XL.OlePropertyGet("Selection").OleProcedure("Copy" );

So far so good. When debugging, the correct cells
are selected and available on the clipboard. Ctrl-v
pastes them when I do it manually. My code to do
the same thing is:

TargetRow = TargetWsheet.OlePropertyGet("Range","A1:A1");
TargetRow.OleProcedure("Select"); // <<=== ***********
XL.OlePropertyGet("Selection").OleProcedure("Paste ");

The problem is that the program exits by throwing
an exception at the indicated line.

Why does that happen? How do I get to paste the
data from the clipboard to the desired location?

Please, do not introduce wrapper classes at this
stage. I do this exercise to understand the basic
workings of COM interaction.

RuA