How Draw a picture using VBA in Excel?

[Baju Antony]

Hello,

Can anyone suggest a method to draw a picture in EXCEL using the VBA.
The picture to be drawn uses some bitmaps and super-imposed by texts
from the excel sheet. The text drawn as picture should match with the
same format as in excel (like font, bold,etc.,)


Thanks in advance
Baju Antony

 

[Anne Troy]

Since Excel doesn't let you copy, and then paste special-as a picture, like
you can in Word, I'm thinking you might be able to use the CAMERA tool? Try
this: Copy some cells. Then, holding the shift key, hit the Edit menu. You
have an extra option to "paste picture". But it's not a bmp or anything...
**** Hope it helps! ****

~Dreamboat
Excel VBA Certification Coming Soon!
www.VBAExpress.com/training/
********************************

 

[Dana DeLouis]

Would anything like this work?

Sub Demo()
Range("A1:C10").CopyPicture _
Appearance:=xlScreen, _
Format:=xlPicture
Range("E1").Select
ActiveSheet.Pictures.Paste
End Sub

Probably won't help, but hopefully may give you something to work with.
Dana DeLouis

 

[Dave Peterson]

Just a note that if you select your range and click on ShiftEdit, you'll get a
"Copy Picture" option that you don't normally get.

In fact, you can shiftEdit and paste Picture link, too.

Dana's code look suspiciously like he recorded a macro when he did it manually.

You could try the same thing if you want to see all the options.

 

[Baju Antony]

Hello All,

Thanks for your response. But I think I have not put the question
properly. I will reframe my question.

The excel sheet has different columns of text data. Each column of the
texts has been formated differently (like font, size,etc). I have to
create a picture on EXCEL sheet using one or more texts.

Some pictures requires a background of another bitmap file(located on
the harddisk).

Hope this is clear

Best regards
Baju Antony