2010 - ImportExportSpreadsheet For Specific Sheet

[EddiRae]

Hello,
I am working with an Excel file that has multiple sheets.

I only want to pull from one of these sheets that is named "Roster".

I am working in a Macro and trying to use the ImportExportSpreadsheet function. I am not seeing where to let this function know that I want to pull data from this sheet. I tried placing in the Range field "Roster!A1:ZZ99999", but that didn't work.

Does anyone know how to accomplish this?

Thanks in advance for your help.
Eddi Rae