Link to a PDF file

[williamr]

I converted an Access database to Excel. In the Access database I had a button that I pressed that linked me to a PDF file for each record. It uses the ID number of the record to locate the image and open it for me. I have little to no knowledge of Excel but my thinking was I could put this code in a cell and it would work - WRONG!! Can someone guide me in the right direction, Please! This is what I put in Excel, it opens the first itemID, #1, but it always opens the ID #1, it does not change to 2,3,4... I put this code in the first 10 cells, but it only opens the first PDF file in my book directory

E:\02-All Photos\18-Books\&"[itemid].value& .pdf"