Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Retrieving hyperlink from MS Access database
Hi!
I have problem to retrieve hyperlinks from MS Access database to Excel worksheet (ADO). everytime when a hyperlink is retrieved to the worksheet it is wrapped with # from both sides for eg: #http:\www.cnn.com# and the link is not working. any suggestions? Thanks in advance for your help! regards E |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Retrieving hyperlink from MS Access database
I don't know how to prevent this, but I do know how to fix your "im-pounded"
hyperlinks. Select the cells and run: Sub hyper_fixer() For Each r In Selection r.Value = Mid(r.Value, 2, Len(r.Value) - 2) r.Select Application.SendKeys "{F2}" Application.SendKeys "{ENTER}" DoEvents Next End Sub This sub removes the leading and trailing pound from each cell and then does F2 to the cell to make the hyperlink "hot" -- Gary''s Student - gsnu200752 "אלי" wrote: Hi! I have problem to retrieve hyperlinks from MS Access database to Excel worksheet (ADO). everytime when a hyperlink is retrieved to the worksheet it is wrapped with # from both sides for eg: #http:\www.cnn.com# and the link is not working. any suggestions? Thanks in advance for your help! regards E |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Retrieving hyperlink from MS Access database
Thanks!
Eli "Gary''s Student" wrote: I don't know how to prevent this, but I do know how to fix your "im-pounded" hyperlinks. Select the cells and run: Sub hyper_fixer() For Each r In Selection r.Value = Mid(r.Value, 2, Len(r.Value) - 2) r.Select Application.SendKeys "{F2}" Application.SendKeys "{ENTER}" DoEvents Next End Sub This sub removes the leading and trailing pound from each cell and then does F2 to the cell to make the hyperlink "hot" -- Gary''s Student - gsnu200752 "אלי" wrote: Hi! I have problem to retrieve hyperlinks from MS Access database to Excel worksheet (ADO). everytime when a hyperlink is retrieved to the worksheet it is wrapped with # from both sides for eg: #http:\www.cnn.com# and the link is not working. any suggestions? Thanks in advance for your help! regards E |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a Product DATABASE in ACCESS or EXCEL and then retrieving | Excel Discussion (Misc queries) | |||
Retrieving Excel Database Data | Excel Programming | |||
Importing Data from an Access Database Including a Hyperlink Colum | Excel Discussion (Misc queries) | |||
Need to keep text format when retrieving records from database | Excel Programming | |||
Retrieving data from a database list | Excel Discussion (Misc queries) |