Setting path to folder as varible and using it.

[Marcusanka]

Good afternoon.
I've hit a dead end. After looking for quite a while and tested a few things I've given up.
Probably a no-brainer to some but I cannot get my head around it.

Is there somehow I can save a specific path to a folder " C:\user\folder1\Subfolder1" and then call upon a variable to go: "path\file1.xml, path\file2.xml, path\file3.xml" in a swift mannor?

Trying to set up a userform with clickable buttons that opens files from a folder with quite the few documents and having to re-specify all the paths in the document would be a pain in the a** when moved to the intended computer and proper location on the host computer.

Thank you!

 

[Marcusanka]

Something like this:

PATH = "C:\USER\FOLDER\SUBFOLDER"

Private Sub Btn1_1_Click()
UserForm1.Hide
Workbooks.Open "PATH\FILE1.xlsm"
ThisWorkbook.Close
End Sub

 

[shg]

Option Explicit

Const sPath As String = "C:\USER\FOLDER\SUBFOLDER\"

Private Sub Btn1_1_Click()
  UserForm1.Hide
  Workbooks.Open sPath & "FILE1.xlsm"
  ThisWorkbook.Close
End Sub

 

[Marcusanka]

Thank you shg! Works like a bloody charm!

 

[shg]

You're welcome.