Solved

Setting a link to a picture stored in ms excel - macro

Posted on 2013-01-18
4
142 Views
Last Modified: 2013-02-07
Hi

I have an excel file that has ~1000 pictures stored in it, along with associated data.   I would like to create a picture file that allows the pictures to be stored outside of the excel file, and outside of my computer (cloud or internet picture handling service like dropbox?) and still available for viewing in the excel workbook file as well as a CSV format excel file....   Some pictures have a link to a web page already available and most do not.   I have a dropbox storage account, and would prefer that the pictures be stored using that service.

Most pictures need to be re-sized as well.

Not every row has a picture.

All pictures are in one column in the spreadsheet.

I use Microsoft Office Picture Manager to edit my pictures, and I'm willing to use another if needed.

The order of events for a macro looks like this to me...
1) Resize the picture and file it in a known location, or file it in a known location and re-size it...
2) save the file location in the column next to the picture
3) delete the actual picture from the spreadsheet location


Is this do-able in excel?

Tom

PS:  I am attaching a file for your
test-file-for-experts-exchange-J.xlsx
0
Comment
Question by:tomwaddell
  • 3
4 Comments
 
LVL 10

Expert Comment

by:broro183
ID: 38797974
hi,

I'm sure something can be worked out in Excel, but I may be wrong...

Before I start playing around can you please explain how you want the files resized (eg size in kb or a set height by width)?

Rob
0
 

Author Comment

by:tomwaddell
ID: 38799022
I was going to resize the files manually, assuming the height by width will stay the same as they get copied.  The height by width of the pictures is not the same for each / all.
0
 
LVL 10

Accepted Solution

by:
broro183 earned 500 total points
ID: 38821049
hi Tom,

Sorry for the very slow response, I thought I had posted this days ago, but it can't have flowed through.

The code in the attached file was originally developed by Bob Phillips & was sourced from:
http://www.officearticles.com/downloads/xlddownloader.zip
after being found via Anne Troy's post:
http://www.excelforum.com/showthread.php?t=388190&p=1035703&viewfull=1#post1035703
 I've made a few changes to work with the layout from your example file.

hth
Rob
xlddownloader-v2.xlsb
0
 
LVL 10

Expert Comment

by:broro183
ID: 38863058
hi Tom,

I'm pleased I could help - thanks for the points :-)

Rob
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

A2 = A1 That kind of cell reference is relative.  If you copy it from A2 to B2, then B2 will get this: B2 = B1 That's all fine and good, but if you then insert a new row above row 2, you'll find: A3 = A1 B3 = B1 This is intentional. …
Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

746 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

15 Experts available now in Live!

Get 1:1 Help Now