| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hyperlinks from one excel sheet to another in VBA
I am trying to programmatically insert a hyperlink into a cell on
sheetA (static name) from various other workbooks whose names all differ. I want to be able to open the referenced sheets from a master sheet. I tried to record a macro that copies and pastes as a link, but it does not record the paste link function. Since the sheet names are all variables except for the master, I know somewhere I need a cell reference. i.e. Cell("filename"), but I need this to run inside a VBA macro. Can anyone help me on this code? Thanks in advance! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Hyperlinks from one excel sheet to another in VBA
Try something like this:
Sub hyper_put() Dim s As String, t As String s = Chr(34) t = "=HYPERLINK(" & s t = t & "file:///C:\Documents and Settings\Owner\Desktop\Book2.xls#Sheet2!B9" t = t & s & ")" Range("A1").Value = t End Sub The contents of A1 will be: =HYPERLINK("file:///C:\Documents and Settings\Owner\Desktop\Book2.xls#Sheet2!B9") -- Gary''s Student - gsnu200738 "Lindleman" wrote: I am trying to programmatically insert a hyperlink into a cell on sheetA (static name) from various other workbooks whose names all differ. I want to be able to open the referenced sheets from a master sheet. I tried to record a macro that copies and pastes as a link, but it does not record the paste link function. Since the sheet names are all variables except for the master, I know somewhere I need a cell reference. i.e. Cell("filename"), but I need this to run inside a VBA macro. Can anyone help me on this code? Thanks in advance! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Hyperlinks from one excel sheet to another in VBA
On Aug 16, 10:36 pm, Lindleman wrote:
I am trying to programmatically insert a hyperlink into a cell on sheetA (static name) from various other workbooks whose names all differ. I want to be able to open the referenced sheets from a master sheet. I tried to record a macro that copies and pastes as a link, but it does not record the paste link function. Since the sheet names are all variables except for the master, I know somewhere I need a cell reference. i.e. Cell("filename"), but I need this to run inside a VBA macro. Can anyone help me on this code? Thanks in advance! Can anyone help me? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I temporarily disable hyperlinks in an excel sheet? | Setting up and Configuration of Excel | |||
| Update 2000 Excel hyperlinks to 2003 hyperlinks | Excel Worksheet Functions | |||
| Excel Hyperlinks- cell content v. hyperlinks | Excel Discussion (Misc queries) | |||
| delete hyperlinks from graphical objects in excel sheet | Excel Programming | |||
| Not able to open hyperlinks from Excel sheet | Setting up and Configuration of Excel | |||
Linear Mode
