Anyone know why this isn't working?
What I am hoping for is if the Column "Program#" contains the word "CALC" to open the .vbs script(works fine), if it contains anything else to open the relevant .tap file(works fine), and if it's empty to do nothing(errors out trying to open 'nothing' I guess).
Code:
Private Sub Program___Click()
If Program__ = "" Then
Exit Sub
ElseIf Program__ = "CALC" Then
LinkName = "\\fileserv\manufacturing\Fadal\Brad\Programs\Calculators.vbs"
Else
LinkName = "\\fileserv\manufacturing\Fadal\" & Program__ & ".tap"
End If
Application.FollowHyperlink LinkName, , True, False
End Sub
What I am hoping for is if the Column "Program#" contains the word "CALC" to open the .vbs script(works fine), if it contains anything else to open the relevant .tap file(works fine), and if it's empty to do nothing(errors out trying to open 'nothing' I guess).