I have a userform (userform1.Mulitpage1("page1")) with multiple checkboxes
when clicking a commandbutton I want to open a file.
I am getting an error message that the file cannot be found.
the problem must be in the Dim or workbooks.open, the sCap1= does result in the correct file name.
can anyone help?
Dim sCap1 As String
sCap1 = userform1.MultiPage1("Page1").CheckBox1.Caption & ".xls"
Msgbox sCap1 << is to test the above to make sure the filename is correct.
Workbooks.Open Filename:="C:\Database\sCap1"
Bookmarks