Pasting clipboard contents using VBA

[brucemc777]

I have read Chip Pearson's information on how to use VBA to paste the contents of the clipboard into a sheet. He states that for this to work I must first "set a reference to the Microsoft Forms 2.0 Object Library.".

Is this strictly to pull in code into the workbook I would be distributing or will any user of the workbook that I distribute it to also have to set a reference for it to work?

I'd rather ask the dumb question than find out the hard way...

Thank-you folks!

[shg]

The reference travels with the workbook.

[LJMetzger]

Hi,

There are 3 ways of accessing clipboard data that I know in VBA:
a. Paste and PasteSpecial
b. Early Binding - requires library reference
c. Late Binding - does NOT require library reference

For a discussion of the first two see: http://www.excelforum.com/excel-prog...ml#post4091725

For an example using Early Binding and example using Late Binding see: https://desmondoshiwambo.wordpress.c...rosoft-access/
NOTE: The 2nd example is using Microsoft Access

Lewis

[brucemc777]

Again, many thanks-

I will read all for though I thought I had found my answer, it wasn't quite. The area that is copied into the clipboard is basically a table, and when I use Ctrl-V to paste it into the worksheet, all is fine, but trying to simply copy the clipboard to a cell jams everything into that cell, and that isn't fine...

[LJMetzger]

The reference travels with the workbook.

I believe this is the case when using the same version of Excel. I believe the reference will come up missing if the destination computer is using Excel 2003, and the source computer is using a newer version of Excel.

Lewis

[brucemc777]

Finding I could simply use "Paste" was an embarrassing surprise, but I am running into a bit of confusion - If I click on a cell then use

Please Login or Register  to view this content.

the entire table drops in perfectly, but if I use vba to select the proper cell as in

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

It again crams everything into one cell.

Any thoughts on how I should position the active cell some other way?

[brucemc777]

Not sure what I did different, but it works like it should now.

Again, thank-you.