Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

inserting a picture by vba-code

24 views
Skip to first unread message

Henning Winkler

unread,
Oct 11, 2001, 9:44:43 AM10/11/01
to
Hi,

I'm using Excel97.
How can I insert a picture, for example "C:\pictures\mypic.jpg" into a
block of cells, for example "A2:K15" by vba-code ? Ist it possible to
format a inserted picture ?

thanks for your help!

Henning

Norman Harker

unread,
Oct 11, 2001, 10:05:32 AM10/11/01
to
Hi Henning!

Here's the basics of inserting a picture with top left at A2.

Sub Macro2()
Range("A2:K15").Select
ActiveSheet.Pictures.Insert("D:\jpgs From the Net\Finance\Euronotes
Pastiche (BBC).jpg").Select
End Sub

As to formatting, I suggest you use the macro recorder and study the
generated code for what you want to do.

hth

"Henning Winkler" <Henning...@t-online.de> wrote in message
news:3BC5A24B...@t-online.de...

Henning Winkler

unread,
Oct 11, 2001, 4:17:16 PM10/11/01
to
Hi Norman,

thanks! Code works well.

Henning


Norman Harker schrieb:

0 new messages