How to select a specific column with Excel VBA

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dennis - 28 Feb 2006 03:38 GMT

Excel 2003

I am exporting hyperlink data from Access to Excel. I plan to use code from
Microsoft KB Article 271856 to turn the text in a specific Excel column back
into a working hyperlink.

I need help with VBA code to select that specific column in the worksheet
that contains the hyperlink data so I can run the code from the KB article.

Signature

Dennis

Reply to this Message

Norman Jones - 28 Feb 2006 06:38 GMT

Hi Dennis,

Try posting your export code.

---
Regards,
Norman

> Excel 2003
>
[quoted text clipped - 7 lines]
> that contains the hyperlink data so I can run the code from the KB
> article.

Reply to this Message

Dennis - 28 Feb 2006 13:41 GMT

Code to export to Excel...
Dim stDocName As String

stDocName = "Table1 Query"
DoCmd.OutputTo acReport, stDocName, acFormatXLS, "c:\dennis\test.xls"

Code from KB271856...
Sub HyperAdd()
'
' 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

Signature

Dennis

> Hi Dennis,
>
[quoted text clipped - 15 lines]
> > that contains the hyperlink data so I can run the code from the KB
> > article.

Reply to this Message