problem reading multiple excel file source in ssis

I have a SSIS package where I am trying to load data from multiple Excel file source into an OLE DB destination. i have 2 problems

1. when i set "OpenRowset = Sheet$A4:Z500" , excel source component generates the following errors : [Excel Source [2]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.
   The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed. [SSIS.Pipeline] Error: Excel Source failed validation and returned error code 0xC020801C. [SSIS.Pipeline] Error: One or more component failed validation. Error: There were errors during task validation.

2. when i set the following properties to to excel connection manager the component wont read the file ExcelFilePath :@[User::FilePath] ServerName :@[User:FilePath]

thanks