Hi Everybody,
I have an Access table with a field filled with outdated hyperlinks. I also have an excel spreadsheet that is the master list for these hyperlinks. The spreadsheet will be updated by someone else whenever the links change. However, I don't always want to have to manually update my links whenever the spreadsheet is changed. Instead of manually updating 100's of hyperlinks, I would like to create a macro or something that will take the hyperlink data from the spreadsheet's cells and replace the hyperlinks in my table. The spreadsheet, however, is not set-up the same way as my table. There are a lot of extraneous links in the spreadsheet, and the pertinant links are not in an order that allows me to easily import the information into my table.
Can someone help me??? I need this information within 24 hours.
Thanks!