I created a drop down screen so users may select a workbook and after selection, the path and the name appear in the box named: SSReportBuilder.xls.UserForm1.SSFileName
While running the code (another button on the form named UserForm1) a message appears stating “Object Required”.
The code it highlights is: FullName = SSReportBuilder.xls.UserForm1.SSFileName.
Since there is a need for this form to be open, I have not been able to test it inside VBA.
Please advise as to how the test may be performed or suggest an alternate way to assign a name to the selected “Full Path Excel file”