Hi,
I am using an input box to to select a folder for where the .xls
workbook is
##########
Sub Macro3()
Dim i As String
i = InputBox("Enter Job Number", , "Job Number")
Workbooks.Open Filename:="C:\" & i & "\Kicking Quotes.xls"
End Sub

#########
Each folder has 1 workbook but the workbook does not always have the
same name.

How can I open whatever workbook is in the folder selected?

Thanks