Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
run app on database "refresh"
Re an Access database query on an Excel sheet ...
This database contains a hyperlink field to individual websites. For unknown reasons, with some sites, it returns their addresses with a "#" on each end, making the hyperlinks invalid. Have created a small sub-routine that runs manually, off a button, which removes those characters, thereby enabling the website. But ... it has to be run manually, each time the "refresh" command is run. The sub's name is Sub FixHyperlinks(). Can anyone please suggest a way to have this run automatically in Excel each time the database query is refreshed? Thanx. - Mike |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
run app on database "refresh"
Right click the sheet's tab, View Code, and paste:
Private Sub Worksheet_Change(ByVal Target As Range) Application.EnableEvents = False FixHyperlinks applicaiton.EnableEvents = True End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Query parameter "refresh when value changes" doesn't refresh - why | Excel Discussion (Misc queries) | |||
Change "relative" to "absolute" (database) | Excel Programming |