Hello,

In my application I create  excel sheets and put data in it with activeX.
Before I close a sheet  to make another sheet I want to copy the contents of
that excelsheet with activeX into a Word document as a bitmap image for
instance on page 3 of the word document.
Anyone knows if this is possible and how to do this?

Hi Hans,

>
> In my application I create  excel sheets and put data in it with activeX.
> Before I close a sheet  to make another sheet I want to copy the contents
> of
> that excelsheet with activeX into a Word document as a bitmap image for
> instance on page 3 of the word document.
> Anyone knows if this is possible and how to do this?

You have to use the following method:

#define wdPasteMetafilePicture 3
#define wdPasteBitmap 4

      oWordDoc:paragraphs:last:range:pasteSpecial( 0, .F., 0,
.F.,wdPasteBitmap )

Regards. Diego

Thanks Diego,

I see that this method is pasting the bitmapimage into the word file.
But how I put it on page 3 of the document?
And what's the method to copy the entire content of the excelsheet?



"J.A. Diego Kerejeta" <diegokerejeta@euskalnet.net> schreef in bericht 
news:5d69f408$683fc092$5b41d@news.alaska-software.com...
> Hi Hans,
>
>>
>> In my application I create  excel sheets and put data in it with activeX.
>> Before I close a sheet  to make another sheet I want to copy the contents
>> of
>> that excelsheet with activeX into a Word document as a bitmap image for
>> instance on page 3 of the word document.
>> Anyone knows if this is possible and how to do this?
>
> You have to use the following method:
>
> #define wdPasteMetafilePicture 3
> #define wdPasteBitmap 4
>
>      oWordDoc:paragraphs:last:range:pasteSpecial( 0, .F., 0,
> .F.,wdPasteBitmap )
>
> Regards. Diego
>
>

Regards. Diego

Diego,

You are fantastic.
Now I can go on.

thanks

"J.A. Diego Kerejeta" <diegokerejeta@euskalnet.net> schreef in bericht 
news:7a5ac178$51401533$5ddad@news.alaska-software.com...
> Regards. Diego
>