assign combobox value to variable in vba

[met1713]

I cant quite figure it out and tried everthing, im assigning a value and then this value declares what workbook it opens in a folder, my comboboxes are on the excel sheet and not in a pop up user form if it makes any difference

what i have so far

dim RandomName as String

RandomName = Me.cboRandomName

"......\friends\RandomName.xlsx"

 

[AOB]

So the value held in Me.cboRandomName - which is subsequently passed to the RandomName string variable - is a path to a workbook which you want to open? Or just the name of a folder / subfolder? If not, how do you derive the full path of the workbook you're trying to open from the combobox?

 

[AOB]

Dim wbk As Workbook

Set wbk = Workbooks.Open(Me.cboRandomName.Value)

With wbk
    ...
End With

 

[met1713]

so i have a master folder that has 6 subfolders and those folders have 64 subfolders and then there are several excel sheets with in those 64 subfolder and basically my excel program has variable inputs (comboboxes) for each folder subset and the excel sheet
6 subfolders - combobox with all the names in subfolder
64 subfolders - combobox with all names in subfolder
excel files - combobox with all excel files


so basically the code looks like

workbook.open ".....\masterfolder\6subfolders\64subfolders\excelfiles.xlsx"

 

[met1713]

i figured it out i need "" and & breaking up my file path and variables. Thanks for your help!!!