Yes, you could read the file name and path into a variable and then use the variables in the expressions property of the connection manager for the excel spreadsheet.