Copyint to clipboard

[Ibrahim Dashti]

Peace be upon you...
I'm writing macros in Office 2007 on Windows Vista and need to make custom
copies to the clipboard. I mean I want to modify the value of the control
before sending it to the clipboard. I tried to use the Clipboard object but
it seems not to be defined. What reference should I add to get access to the
Clipboard object?!!

 

[Karl E. Peterson]

Peace be upon you...

Likewise, I'm sure.

I'm writing macros in Office 2007 on Windows Vista
Ouch^2!

and need to make custom
copies to the clipboard. I mean I want to modify the value of the control
before sending it to the clipboard. I tried to use the Clipboard object but
it seems not to be defined. What reference should I add to get access to the
Clipboard object?!!

There is no Clipboard object in VBA. You can roll yer own, though. Here's one
example:

http://vb.mvps.org/samples/ClipEx

That same technique could be extended to just about any format you want to support.