Hi there amigos

I recently created a large (for my standards) database. Every file name is linked via hyperlink to the PDF file it represents so that when u click on it it opens the newspaper, circular, Agenda etc in Acrobat...

Well all these files were stored on CD so the hyperlin address started with E:\. On other computers tho CD Drive is commonly named D:\ and when I open the Excel spreadsheet there, none of the links work.

In my search for a solution I found out that if I just ommit the drive letter from the Hyperlink path and just enter it in File\Properties\Summary\hyperlink it works just fine.

But its a complete nightmare going through every single file changing the hyperlink paths...Any suggestions???


Thanks in advance