QTP Import excel file from QC Test Resources Module

[Arunpradeep Anbuselvan]

Hi,

I want to import the data from the QC Test Resources to QTP datasheet.
I have used below piece of code but getting the error message saying
"The DataTable.ImportSheet operation failed. Invalid file." The
"strExcelPath" string is displaying the local path.

strExcelPath=PathFinder.Locate("[QualityCenter\Resources] Resources
\BPT Resources\AutoTestscript3_POC.xls")
Msgbox strExcelPath
DataTable.ImportSheet strExcelPath ,"CA" ,"StateSpecific"

Could somone help me out to get rid of this error.

Earlier I tried with importing excelsheet from QC Test Plan
attachments section but it didnt worked.