Today is

By: Ikedi Ani-okoye.

A Clipboard in macro

How do I access the Clipboard in a Macro? Just using GetData and SetDataObject does not work. This article will show you how.

You would think that the Clipboard object would work the same in a Macro as it does in an application. That would not be correct. If you simply try to use the clipboard in a Macro, your code will fail due to the way that macros work at the behest of the IDE. The error you will get is the old "object not set to an instance of an object" message. Therefore, to make a long story short, you need to create a separate thread to access the Clipboard.

Using a Clipboard

A clipboard doesn’t require holes be punched in the paper it holds. Pages and notes can quickly and easily be added or removed. It is portable, sturdy, comes in a variety of colors, and has a handy spot for my pen when it is time to get to sleep. A clipboard allows my inner preschooler to manipulate pen and paper. I may go where electricity may not be found and give my eyes a rest from the bright lights of a computer screen.

Surely a woman who needed to prepare her daughter’s birthday party between doing several loads of laundry and bathing her children was the original creator of the clipboard. Maybe she had a letter to her Kindergartener’s teacher to write while her 3-year-old played on the playground. It is highly likely that she had grocery lists, to-do lists, and Christmas card lists to compile while waiting in the Dentist’s office.

Windows clipboard

The Windows clipboard is a convenient tool you can use to copy or move information from one place to another. To use the clipboard, simply select the text, image, or other item you want to copy or more to another place. If you want to copy an item from one place to another, first copy the item to the clipboard. Select the place where you want to copy the item to and paste the item. If you want to move an item from one place to another, first cut the item to the clipboard. Select the place where you want to copy the item to and paste the item.

CONCLUSION

A memory object on the clipboard can be in any data format, called a clipboard format. Each format is identified by an unsigned integer value. For standard (predefined) clipboard formats, this value is a constant defined in Winuser.h; for registered clipboard formats, it is the return value of the Register clipboard format function.

Except for registering clipboard formats, individual windows perform most clipboard operations. Typically, a window procedure transfers information to or from the clipboard in response to the WM COMMAND message.