VBA to a Hyperlink to another workbook

[DWM]

Hi I have several workbooks I would like to open using a button.

The file names can change. So these are typed and hyperlinked in a range on cells on my sumary workbook.


I currently have a macro running but it seems to link top the previous filename that was save din the cell.


Current VBA:


Sub OpenFiles()

'

' OpenFiles Macro

' Opens all asscoiated files

'


'

Range("C46:L46").Select

Selection.Hyperlinks(1).Follow NewWindow:=True, AddHistory:=True

ActiveWindow.ActivateNext

Range("C48:L48").Select

Selection.Hyperlinks(1).Follow NewWindow:=True, AddHistory:=True

ActiveWindow.ActivateNext

Range("C50:L50").Select

Selection.Hyperlinks(1).Follow NewWindow:=True, AddHistory:=True

ActiveWindow.ActivateNext

Range("C52:L52").Select

Selection.Hyperlinks(1).Follow NewWindow:=True, AddHistory:=True

ActiveWindow.ActivateNext

Range("C54:L54").Select

Selection.Hyperlinks(1).Follow NewWindow:=True, AddHistory:=True

ActiveWindow.ActivateNext

ActiveWindow.ActivateNext

ActiveWindow.ActivateNext

ActiveWindow.ActivateNext

ActiveWindow.ActivateNext

Range("C55").Select

End Sub

 

[Hui]

DWM


Do you still need this answered or does your other post replace this question ?

Refer: http://chandoo.org/forums/topic/macro-to-open-filename-held-in-a-cell