Hi,

I want to embed images (NOT links) in my EXL2K report so that I can see the images when I am out of the network too (if I save the report file). Please help. Thanks!

This message has been edited. Last edited by: Kerry,

quote:

Don't ever say it can't be done !

Funny you should ask for this, as I have just created a utility that will add an image to EXL2K output.

But there are limitations.

1. The workbook must have multiple sheets.
2. The image shows in Excel 2003, 2010, but not in 2007.
3. The parts of the utility use Unix commands.
4. It only works for a held report, not returned to the browser.

Wew! Thanks for saving me from an embarrassing moment Warren. I was going to say that it could not be done. Well, technically it can't be done exactly as most of us expect but you've proven us wrong.

It will be interesting to get the technique out there to see how it goes with the myriad of Excel verions

Waz - care to share?

I'll desensify (Is that a real word?) the fexes and post the code and samples.


FYI

I've also only tested this on 7.1.6, 7.6.6 and 7.6.11, other versions may have issues with the technique.

Thanks Waz! I am waiting for you to share the fex/logic... :-)

This message has been edited. Last edited by: Prash1983,

I'll see if I can prep it and post it tomorrow (my time).

Thanks in advance Waz.

Have you tried calling an excel macro to do this?

The solution can be completely driven by a macro / template.

I thought that I had posted a solution for this a couple of years ago but the post has disappeared and I cannot find the code.

Basically there are 2 options.

1st the images if static can be included in a 2nd worksheet and can be moved to the required location by a macro on open.
2nd the images are stored on the application server and the macro resolves and embeds the image on open.

You include macro code so that it only executes on 1st open. i.e. when opening the saved version it does not run the macro.

Quite a few good examples on the WWW.

I'll keep looking for my example.

For those that may be interested, I have made available the programs and samples..

http://forums.informationbuild...067021216#3067021216

Thanks Waz. I'll try to devote some time to analyze those. I'm sure there will be more than a few gems buried in there.

Hopefully not too many bombs, it was thrown together quite quickly.

I'll be prepared!