Creating multiple hyperlinks to files in a folder - one file per hyperlink per cell

[fsusd]

I am trying to insert hyperlinks for picture files into cells down a column in Excel 2007. I have a folder on the local drive which contains barcode images. The images are named: barcode001.png, barcode002.png, barcode003.png...on up to barcode319.png. I am able to click on a cell (say B1) and create a hyperlink to the first image and I can click on the next cell down (B2) and create a hyperlink to the second barcode image and on down the file but I'd rather find a way to get all 319 cells filled in fast. Each cell points to the next barcode image. Seems like there would be a macro or something that could point to the first barcode, then for the next cell use the same link but ratchet up one number, then add another number to the filename for the next cell down and so on.

I was originally guessing I might be able to get the first two or three cells done manually and simply drag down the column to have the cells auto fill much link you can do by keying in a 1 in the first cell and a 2 in the next cell and drag to get 1, 2, 3, 4, 5, 6, ....

That would have been just too easy I guess because that didn't work for me at all. I've looked through Google searches and through many posts in this forum and haven't come across exactly what I'm trying to do. Please point me in the right direction if you know how to do this.

Thanks,
Steve

[jmac1947]

Hi Steve,

(and welcome to the forums )

I use the following code to create a hyperlink to a worksheet in my workbook from a "list of all worksheets" each time after i add in a new worksheet which may be worth exploring

Please Login or Register  to view this content.

If you set the range to your list (B1:b319) for the selection yopu should get close

[jmac1947]

again, maybe not

I just reread your post in a bit more detail. My code expects the "target" to be in same workbook so the change tot he c.hyperlinks.add will be a bit more complex. The VBA help may be of assistance if nobody else chimes in with the complete solution... sorry

Jmac

[fsusd]

Thanks for the thought jmac1947. I am hoping I get a response that will point me to a files located in a folder on the local drive but I'll definitely experiment with tweaking what you posted if nobody has any other ideas.

Steve

[fsusd]

Just found the script I needed in a different post in this forum located here: http://www.excelforum.com/excel-prog...en-folder.html

In that post, there's a link to this page which has the exact script I needed. Very cool.

Thanks!