I am trying the following:

Workbooks.Open FileName:="O:\Splitsen\" & Range("J2") & ".xlsx"
If cell J2 has value/text: test

and I run the macro it states "O:\Splitsen\.xlsx not found". While it should open workbook O:\Splitsen\test.xlsx