Good Afternoon Guys
On a userform with a button to open another workbook and close the current one, I use this code..... It works fine, however it will be used by different people and may need to sit on different drive for some.
The folder structure will remain the same but how do I change it to automatically detect and change the path for the different drives
Private Sub cmdhands_Click()
Workbooks.Open Filename:="H:\Compliance Information\H&S\H&S Access.xls"
ThisWorkbook.Close SaveChanges:=True
End Sub
Many thanks for your help
JT
Bookmarks