By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,561 Members | 3,127 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,561 IT Pros & Developers. It's quick & easy.

Replacing old hyperlinks in a table automatically from an excel spreadsheet

P: 72
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!
Jun 1 '07 #1
Share this Question
Share on Google+
1 Reply


Rabbit
Expert Mod 10K+
P: 12,366
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!
From the information you've given, this can't be done.

1) The tables are in a different format.
2) There are a lot of extraneous links, but you haven't said if there's a way to tell them apart from the pertinent links.
3)The links are in some sort of random order. This prevents any sort of automation because automation requires at least some semblance of order.
Jun 1 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.