Test casees automated using ALM with BPT and QTP 11.

Test casees was set to dynamic data that was mapped to test resource folder in the form of excel.

When you run the Test cases in Test Lab manually means select Test Cases and click run that moment, it was taking dynamic data from resource, working fine as expected.

But when run the same Business processes using OTA, it was taking static data instead of dynamic.

pl provide solution

I have used the below code:
Set tdc = CreateObject("TDAPIOLE80.TDConnection")
tdc.InitConnectionEx "http://qctest:8080/qcbin"
tdc.Login "Username", ""
tdc.Connect "STD", "Projectname"
Set TSetFact = tdc.TestSetFactory
Set tsTreeMgr = tdc.TestSetTreeManager
Set tsFolder = tsTreeMgr.NodeByPath(nPath)
Set tsList = tsFolder.FindTestSets("Phase")
Set TSTestFact = theTestSet.TSTestFactory

Set Scheduler = theTestSet.StartExecution("")
Scheduler.RunAllLocally = True

set obj = theTestSet.StartExecution("LocalHost")
obj.RunAllLocally = True

with regards