Forgot password? | Forgot username? | Register

Copy/Paste Excel Reports with Images

Copy/Paste Excel Reports with Images

Hi all,

I'm trying to find a simple (non VB code) way to display thumbnails in excel reports constructed using the quick copy and paste from list view method.

When copying and pasting as csv into excel, the thumbnail that is displayed in EMu's list view gets converted to the file path where the multimedia is temporarily cached. (C:\Users\rcraick\AppData\Local\KESoftware\Cache/33/442/MM_33442.jpg)

Is there a clever way to replace this filepath with the image/thumbnail so the thumbnail is visible in excel?

We use this type of quick one-off report when external contractors (non emu users) need to update data in such a ways that I can re-import it into emu - so retaining the strict csv format is essential (which doesn't occur when using the "save as .xls" from crystal viewer.)

Thanks for any suggestions!

Rowena

Edited by: Rowena Craick - 18-Mai-16 14:03:26

Administrator has disabled public posting. Please login or register in order to proceed.

Re: Copy/Paste Excel Reports with Images

Hi Rowena,

This might work for you.  It has a free trial download and some videos on the website to see how it works.   It pulls the image from the cache file path.  It's called Excel Image Assistant. 

Good luck,
Deb

Administrator has disabled public posting. Please login or register in order to proceed.
There are 0 guests and 0 other users also viewing this topic

Board Info

Board Stats
 
Total Topics:
599
Total Polls:
0
Total Posts:
1362
User Info
 
Total Users:
814
Newest User:
Paul
Members Online:
3
Guests Online:
96