Article ID: 140204
Article Last Modified on 1/9/2003
APPLIES TO
- Microsoft Visual Basic 4.0 Standard Edition
- Microsoft Visual Basic 4.0 Professional Edition
- Microsoft Visual Basic 4.0 Professional Edition
- Microsoft Visual Basic 4.0 16-bit Enterprise Edition
- Microsoft Visual Basic 4.0 32-Bit Enterprise Edition
- Microsoft Visual Basic 3.0 Professional Edition
- Microsoft Visual Basic 3.0 Professional Edition
This article was previously published under Q140204
SYMPTOMS
After copying part of an embedded OLE object, and pasting the contents of the clipboard to the form while the form has the focus, a graphic representing the object is inserted onto the background of the form.
CAUSE
When you copy certain OLE objects from an OLE container, more than one form of information is copied to the Clipboard. For example, when you copy cells from an Microsoft Excel spreadsheet, objects in both bitmap and enhanced metafile format (among other objects) are copied to the Clipboard. Then when the object is pasted onto a Visual Basic form it causes the form's Picture property to be set to the bitmap of the copied cells. There is no way to position or manipulate the image if it is added to form in this manner.
STATUS
This behavior is by design.
MORE INFORMATION
Steps to Reproduce Problem
- Start Visual Basic 4.0, or if it is already running, click New Project on the File menu.
- Double-click on the OLE Client control in the toolbox to add a new OLE client to your project. When the Insert Object dialog box appears, select "Microsoft Excel Worksheet" and click OK.
- Type some text into the cells of the embedded worksheet. Select the filled in cells and click Copy (or press CTRL+C) on the Edit menu to copy the cells to the Clipboard.
- Click a location on the form that is not covered by the OLE control. Press CTRL+V to paste the contents of the Clipboard to the form. The result is a representation of the cells in the upper left-hand corner of Form1. If the Picture property of the form is examined, it no longer is the default "None," instead it is the value "Bitmap."
Additional query words: 4.00 vb4all vb4win
Keywords: kbprb KB140204
