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 summary workbook.
I currently have a macro running but it seems to link to the previous filename that was saved in the cell when I set the macro up.
Current VBA:
[pre]
[/pre]
It also appears that from DATA/ Edit Links that it is using the old file.
Any help would be much appreciated
The file names can change. So these are typed and hyperlinked in a range on cells on my summary workbook.
I currently have a macro running but it seems to link to the previous filename that was saved in the cell when I set the macro up.
Current VBA:
[pre]
Code:
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
It also appears that from DATA/ Edit Links that it is using the old file.
Any help would be much appreciated