i have a QTP function that loads (imports) a datasheet into the local datatable from a spreadsheet. it uses a relative path from the executing script. when i run the test script locally that references this, it works fine. when i load everything into QC (retaining the same folder structure), the function fails to import the datasheet. should i be able to do this?

routine for loading datasheet
<font class="small">Code:</font><hr /><pre>
Dim okToProceed : okToProceed = true

Sub loadDataSheet(sourceFile, sourceSheet, targetSheet)
DataTable.AddSheet(targetSheet)
DataTable.ImportSheet sourceFile, sourceSheet, targetSheet
If DataTable.GetSheet(targetSheet).getRowCount = 0 Then
Reporter.ReportEvent micWarning, "loadDataSheet", "Failed to load datasheet. File: " &amp; sourceFile &amp; ". Source Sheet: " &amp; sourceSheet &amp; "."
okToProceed = false
End If
End Sub
</pre><hr />

in my test script i make the call as...

<font class="small">Code:</font><hr /><pre>
loadDataSheet "..\..\..\..\DataTables\prLogin.xls", "standardGlennLogin", "prPopulateSignIn"
</pre><hr />

the folder structure is...
- Mainline
--DataTables
--Records
---PVM
----NP
-----TestScript (QTP test)

thanks,

glenn