OLE & Excel

I'm trying to populate an Excel spreadsheet using OLE. I can insert text and values into cells, but one thing I really need to do is paste an image from the clipboard into Excel.

In Excel VBA, a paste is done by:

Worksheets("Sheet1").Paste

But I dont know how to do it with Builder.

I can do things like:

my_excel.OlePropertyGet("Workbooks").OlePropertyGet("Item",1).OleProcedure("SaveAs","d:\case1.xls");

and

my_excel.OlePropertyGet("Workbooks").OlePropertyGet("Item",1).OleProcedure("PrintOut");

and

my_range.Exec(SetValue << "My Excel Worksheet");

But I am mistifed by the syntax of this lot, I've just cribbed it from other code.

Can anyone help?

Thanks - Paul.
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories