Insert a bmp file

[Jeff Barnes]

Hi,

I have an application that uses excel to generate the reports.
What I need to ba able to do is have excel insert a bmp image when the file is opened.

The image in the bmp file will change depending on the user but the file name will stay the same.

Is there any way of doing this?

I wanted to do something like =File("\MyDir\MyBmp.bmp") or what ever will work.


Thanks,

Jeff

 

[erik.van.geit]

Hi, Jeff Barnes
Welcome to the Board !!!!!

you could record a macro to get the syntax
menu tools/macro/record macro

actions to do
menu insert / picture / from file
etcetera

stop recording

check the code

    ActiveSheet.Pictures.Insert("C:\WINDOWS\Desktop\home.jpg").Select

1. you don't need the "selection" (so deleted ".Select"
2. perhaps you need a specific location

Range("B5").Select
ActiveSheet.Pictures.Insert ("C:\WINDOWS\Desktop\home.jpg")

there are more "professional" ways to do this ... but this could well be just what you need

kind regards,
Erik

 

[Jeff Barnes]

Hi Erik,

Using your idea I was able to add the following code to my program and it does exactly what I need.

oSheet:Range("A1","A1"):Select()
oSheet:Pictures:Insert( cFile )


Thanks for the fast reply,

Jeff