tomwaddell
asked on
Setting a link to a picture stored in ms excel - macro
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
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
ASKER
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
hi Tom,
I'm pleased I could help - thanks for the points :-)
Rob
I'm pleased I could help - thanks for the points :-)
Rob
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