Hello community,
I am new to this and I am trying to make a tool for a collogue to open work files and hyperlinks in a list. Below is my code that I cannot get to open a file or link:
Below is the sample list:
I am new to this and I am trying to make a tool for a collogue to open work files and hyperlinks in a list. Below is my code that I cannot get to open a file or link:
VBA Code:
Sub FileOpener()
'
' FileOpener Macro
'
Dim NValue As String
Application.Worksheets("Report").Activate
Range("A2").Select
Do While ActiveCell.Value <> 0
NValue = ActiveCell.Value
ThisWorkbook.FollowHyperlink NValue, NewWindow:=True
ActiveCell.Offset(1, 0).Select
Loop
' Keyboard Shortcut: Ctrl+o
'
MsgBox ("Finished with no errors")
End Sub
Below is the sample list: