Solved

Copy photo from one a Excel to another based on common key

Posted on 2014-11-07
5
180 Views
Last Modified: 2014-11-12
Any idea how to copy picture from one file to another based on the a common key ?
0
Comment
Question by:AXISHK
  • 2
  • 2
5 Comments
 
LVL 24

Expert Comment

by:Phillip Burton
Comment Utility
Lots of ideas. Just no idea what you are talking about.
0
 

Author Comment

by:AXISHK
Comment Utility
Excel 1
ID                  photo
123               photo1
356               photo2
ATF               photo3
901               photo4


Excel 2
ID                  Price          Photo [link to here]
901               56.7            
123               12.7
ATF               9.78
0
 
LVL 24

Assisted Solution

by:Phillip Burton
Phillip Burton earned 250 total points
Comment Utility
I think you need to provide an example spreadsheet, because whilst I am slightly clearer, I don't know in what format you currently have the information.
0
 
LVL 27

Accepted Solution

by:
Glenn Ray earned 250 total points
Comment Utility
If the photos are embedded in the Excel file like this:
examplethen you won't be able to link to them.  Even linking to the associated cell will produce no results.

If the photos had the ID value in their filename somewhere, you might be able to create a link to that file and have the image displayed.

-Glenn
0
 

Author Closing Comment

by:AXISHK
Comment Utility
Tks
0

Featured Post

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Suggested Solutions

This article is the result of a quest to better understand Task Scheduler 2.0 and all the newer objects available in vbscript in this version over  the limited options we had scripting in Task Scheduler 1.0.  As I started my journey of knowledge I f…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now