Need help using a relative path in VBA

M

mitch93

Joined
Apr 5, 2017
Messages
1
Reaction score
0
Hello everyone, I am currently using excel 2016 and am very new to VBA. I have a very simple program which entails when a button is clicked it will pull up the manual for the tool. I have it working when i use an absolute path. Problem is when other co workers need to use this excel sheet we dont have the network that we share defined the same. Mine is X: while another co workers is Z: hence needing relative paths. This is my code so far i am wondering what needs to change to make it a relative path.


Private Sub Dewalt_Angle_Grinder_Click()

intMessage = MsgBox("Do you want to see the Dewalt_Angle_Grinder_Click?", vbYesNo, "manuals")

If intMessage = vbYes Then

ThisWorkbook.FollowHyperlink "X:\Tools\Tool Manuals\dw818.pdf"

End If
intMessage = vbNo
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hyperlinks property return a relative path ... 5
Excel Need assistance with modifying a Duplicate declaration. 13
Excel Providing user message when RED X clicked & properly closing application. 2
Relative path in database query connection string 1
Relative Path to a Folder 3
Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox 0
relative path for const in vba code 5
VBA Excel - Select a value from one cell in Excel to update a SQL table 1

Top