|
I have thousands of pictures, not porn believe it or not..., I need to hotlink all these pictures separately into individual cells. So what I'm doing now is right clicking on the cell, choosing hotlink, and browsing to the photo. I've probably done 100... and figured there has to be a better way. I found this and am going through it now... http://forums.esri.com/Thread.asp?c=3&f=39&t=150522 But I know nothing of 'scripts' etc. Thanks. Anyone use hotpotato.avx ??
|
# ¿ Aug 13, 2012 16:02 |
|
|
# ¿ May 20, 2024 15:17 |
|
DukAmok posted:Do you already have a list of all the file names? I've done something like this before, I used some VBA to import all of the full file directory names ("C:\Folder\File1.jpg") into distinct rows, so I had a big list of non-linked strings in the cells. Then I looped through them again and used this little snippet to make each cell link to the destination contained within the cell: Might be easier to show you.... I have photos of doors, with varying numbers of photos per door. Anywhere from 1-8 photos. I know which photos go with which door and am working on renaming them something that makes sense. Photo# 8-101-1 = Bldg. 8, Door 101, 1st photo,... etc. I then have a speadsheet with other door information and then within the spread sheet I want to hotlink to the various photos. I'm not sure what you are describing would work the way I have the spread sheet set up. Or maybe it will work on a different tab and then I could just cut and paste the link in my spreadsheet. I'm kind of at a loss when it comes to 'code' etc. like you posted, so if anyone has an idea you are probably going to have to walk me through it. Thanks.
|
# ¿ Aug 13, 2012 19:14 |
|
DukAmok posted:Yeah, I can't quite make out the data on the spreadsheet but as best as I can tell, there isn't a quick and easy solution with the way that's set up. If your images were all named in a sort of hierarchical fashion, or there was a reference to translate those image names into that hierarchy, we could construct a pretty complex script to parse through those and assign links to your cells, but honestly that's not entirely useful, it might end up taking as much time as clicking a bunch, depending on how many links you have. I'm pretty tied to it for this project, but we may have similar things in the future. Thanks a ton. I thought I thumbnailed that spreadsheet image... FrankeeFrankFrank fucked around with this message at 13:52 on Aug 14, 2012 |
# ¿ Aug 14, 2012 13:48 |