[RESOLVED] How Do I Paste From Cliboard To Excel?

[viperbyte]

Good morning all.

I want to copy data from a website and paste it into Excel. Can someone please help me with pasting into Excel?

-Juan

[HanneSThEGreaT]

Make use of the Clipboard object.

It provides you with the GetData, GetText, GetObject and SetData, SetText and SetObject methods with which you can use to manipulate your data. If you're going to paste into an external program, you'll need the related APIs ( Such as FindWindow and FindWindowEx ) and use it while pasting

[Cakkie]

You can also use the Microsoft.Office.Interop namespace to interact with Excel directly, which will give you a much greater control on how you can transfer the data. You will need to add a reference to Excel, so you will need to have that installed on the computer running your program.

[viperbyte]

Thanks everyone. You guys rock.