Hi All!

I am using MS Excel Object in my VB .Net code and trying to copy the user-selected cells (may be multiple cells) into the clipboard. So far, I have been unsuccessful to get it done. Can any one of you please let me know if it is doable, if so then how?

In order to provide this functionality in my application, I have a form which has an embedded window for Excel and a button to "Copy-Paste" the user selected rows from the Excel document into a Word document.

In nut-shell, I am unable to copy the user selected cells/ rows/ columns from MS Excel into the clipboard.

Best regards,

Azhar

Can't you define an array made up of the cell dimensions then pass the values from Excel range to your destination application. Replicating the copy paste process?

Cheers

Matthew

Hi Matthew!

Thanks for your reply. The scenario is a bit different than what you are talking about. I am selecting few cells from the interface by just clicking on the first cell, and then clicking on the other one while pressing shift key. I can even select a picture on the work sheet. Now, if I do CTRL + C or just select COPY option from the Edit Menu, all my selections are copied in the clipboard (which is quite normal). At this point, I want to put my application button which should work like CTRL + COPY or just copy my selections into the clipboard, through code only. As I mentioned earlier, Excel is embedded in my app using Framer control that I got from MSDN site. I have EXCEL object in the code and WORD object as well. I hope this description is clear to you now.

Thanks

Azhar