Hyperlinks to OLEObjects

[jamesib1971]

Hi I'm building a parts list data base which has embedded pdf's (this is so it can be accessed offline by anyone)

I have built a test spreadsheet to get the logic right before expanding it too 200+ parts

There are four columns and in column D I have created a Hyperlink named the same as the cell with the following code behind it:

Please Login or Register  to view this content.

In the Data sheet worksheet I have placed the pdf files and named them the same as the part numbers.

This code works fine but not very scaleable in terms of the 200+ parts to be added to the actual sheet.

The sheet has to be maintained and lines added and deleted when necessary so I would like this to be as easy and automated as possible could you help please?

I have attached example Sheet to hopefully illustrate.

[sintek]

Hey there James

What happened to your thread here

Anyway...I would do it this way...See attached

[dangelor]

Not tested...
Code created a dictionary of listed parts and then if the target value exists -

Please Login or Register  to view this content.

[jamesib1971]

Thank you so much for the help this works perfectly,

[sintek]

Glad I could contribute...Tx for rep...
Please remember if that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.