Inserting Image in Excel using Macro

[yurok]

Hi guys,

I have .BMP and .JPG images
Is there a way to insert them in Excel spreadsheet using VB Macro.

Thanks a lot

 

[SkipVought]

Hi,

Turn on the macro recorder in Excel and insert the pix. Then observe the code that was generated.

Skip,

_{[red]Be advised:[/red] It's been reported that a wee psychic is roaming the countryside.
Small Medium @ Large!}

 

[yurok]

Skip, thanks a lot,
amazingly it works

 

[TrfTech]

I am trying to assign an image to a cell in Excel and change it conditionally by running a loop in VB code. I referenced a previous request on the subject and have created a macro which inserts a graphic into Excel. It pastes the image in the upper left hand corner of the worksheet but is not assigned to a specific cell. I looked at the code and tried to assign a cell to the picture but it continued to bomb out.
Help please.

 

[SkipVought]

TrfTech,

Please post this as a NEW STRING.

Skip,

_{[red]Be advised:[/red] The dyslexic, agnostic, insomniac, lays awake all night wondering...
"Is there really a DOG?"}