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

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/
********************************

"Baju Antony" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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

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


"Baju Antony" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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

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 wrote:
>
> 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

--

Dave Peterson
(E-Mail Removed)

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





"Dana DeLouis" <(E-Mail Removed)> wrote in message news:<(E-Mail Removed)>...
> 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
>
>
> "Baju Antony" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > 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