Hi i am trying to get a user to select a file and set tht file path as a string then with that string set that as a workbook since i am trying to reference an outside workbook and worksheet but getting an error here
Set Wbl = wokrbooks.EUR_FName
Object required run time error 424
not sure what i need to do to fix this
Set Wbl = wokrbooks.EUR_FName
Object required run time error 424
VBA Code:
Sub get_data()
Dim OpenFileName As String, srcWS As Worksheet
EUR_FName = Application.GetOpenFilename("Excel files (*.xls*), *.xls*")
Dim Wb1 As Workbook
Set Wbl = wokrbooks.EUR_FName
Set srcWS = Wbl.Sheets("Sheet1")
not sure what i need to do to fix this