Re: Problem writing Excel formulas via ODBC

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance


Thanks very much for that...

Now I am planning to insert file location (Hyperlink Address) to Excel
cells. I am planning to use a following macro to solve above
problem...

Private Sub Worksheet_Activate()
Hyperlinks.Add Anchor:=Selection, _
Address:="file:\\C:\Automation\Code-Auto"
End Sub

what type of function definition will give me above requirement. I.e.
if any cell contains file location, I need hyperlink with that location
and friendly name should be cell name.....

can you please help me out...

Thanks in advance...

Regards,
srikantha


--
srikanthaPosted from http://www.pcreview.co.uk/ newsgroup access

.

Relevant Pages

  • RE: Hyperlinking in a Pivot Table
    ... Creates a shortcut or jump that opens a document stored on a network server, ... When you click the cell that contains the HYPERLINK ...
    (microsoft.public.excel.misc)
  • RE: Linking in Excel
    ... Find links in a workbook ... To select the cell with a link, select the row in the box at the bottom. ... Creates a shortcut or jump that opens a document stored on a network server, ... When you click the cell that contains the HYPERLINK ...
    (microsoft.public.excel.misc)
  • RE: Linking in Excel
    ... Find links in a workbook ... To select the cell with a link, select the row in the box at the bottom. ... Creates a shortcut or jump that opens a document stored on a network server, ... When you click the cell that contains the HYPERLINK ...
    (microsoft.public.excel.misc)
  • RE: Excel 03 VLOOKUP hyperlink referencing and formatting
    ... You just need to fix the table that VLOOKUP() examines. ... The cell displays "the news" and is clickable ... This is useless to HYPERLINK() because it wants the real URL, ... master sheet occurs. ...
    (microsoft.public.excel.misc)
  • Re: Lookup returns hyperlinked values as normal text
    ... "Dave Peterson" wrote: ... And get that hyperlink. ... "KarenF" wrote: ... when I click the cell it doesn't go anywhere. ...
    (microsoft.public.excel.misc)