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,
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.
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.