Auto-paste from clipboard to excel workbook

[sky123]

Hi, i'm wondering is there a way (a macro or a program) to automatically paste content from clipboard as soon as it gets there to Excel 2007 workbook ? for example to column A, but not to overwrite existing data, just to add data at the end of column A(next empty cell)...i'm asking because i'm copying data from an online database, and i can't select multiple data at the same time..i need to do it one by one..and i constantly need to change windows from web browser to excel..browser - ctrl-c, click on excel workbook - crl-v, and click back to browser...it would be ideal that content is autopasted to excel as soon as i select Ctrl-c..

Again..sorry for my bad english, and thanks in advance for your help

[tlafferty]

Take a look at the Data ribbon. There's an option that allows you to get web data.

[sky123]

Well that can't work in this situation...because i'm using find form in that web page to display certain data and then i copy it one by one...i need something like i stated in the first post...

[ffffloyd]

VBA and Excel macros let you control what happens inside Excel (more accurately, inside any of the MS-Office programs) but not outside.

Since your source is from a web application, it would probably be more worthwhile looking to see what you can write in a scripting language as an add-on to your browser to paste into Excel after you hit ctrl-C.

[sky123]

Well with a bit of more research, i found this usefull application...ClipTrip, it basically records all entries to the clipboard in a textbox and doesen't owerwrite previous entries..so you just click ctrl-v, it records it automaticly...and when you'r done, you just copy the entire content of ClipTrip textbox to Excel instead of a need to paste evrey single line individualy...