A personal repository of technical notes. - CSC

Excel Tips

Create Custom Macro Workbook
  1. Create new workbook for custom macros.
  2. Save workbook in a folder with no other items.
  3. Hide workbook:
  4. Configure Custom Macro Workbook to automatically open by placing folder name in:
    Excel/Tools/Options/General/At startup, open all files in:
Dynamic Hyperlink Formula
View Web PageQuery String Value
=HYPERLINK("http://www.mydomain.com/mypage.htm?name="&B2, "View Web Page")MyValue1
=HYPERLINK("http://www.mydomain.com/mypage.htm?name="&B3, "View Web Page")MyValue2
=HYPERLINK("http://www.mydomain.com/mypage.htm?name="&B4, "View Web Page")MyValue3

Macro to Convert Text Hyperlink to Working Hyperlink

Sub HyperLinkConvert()
       ' From Microsoft: http://support.microsoft.com/kb/271856
       ' Converts each text hyperlink selected into a working hyperlink
       For Each xCell In Selection
              ActiveSheet.Hyperlinks.Add(Anchor:=xCell, Address:=xCell.Formula)
       Next xCell
End Sub

2012-10-30 Added "Macro to Convert Text Hyperlink"
2012-08-30 Added "Dynamic Hyperlink Formula"

No comments:

Post a Comment