inserting an image

JAN777
04-01-2003, 12:27 AM
how can I insert an image in Excel. It has to come on a specified place.
I give a command from VB to excel to insert one but it doesn't come on the right place. Is it possible to specify this place where the image must come.

JordanChris
04-01-2003, 06:07 AM
Turn on the Excel macro recording facility
Insert the image manually
Turn off the recorder, and check the macro produced.

JAN777
04-01-2003, 06:40 AM
If I use a macro, the image isn't on the right place. I jumps to below.

Maybe I can load an image in an imagebox in excel. But how can I do that from my program?

Insomniac
04-01-2003, 08:08 AM
If I use a macro, the image isn't on the right place. I jumps to below.

Maybe I can load an image in an imagebox in excel. But how can I do that from my program?

ActiveSheet.Image1.Picture = LoadPicture("C:\MyPic.jpg")

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum