Thanks for your support. Given trick works only if the sub test is using a static file name.
I found out a method in MSDN forum to bind excel data source during run-time.
row = TestContext.DataRow.Table.Rows(1)
actual = row(
The above code is working fine. But I'm unable to control the iteration, i.e, if the excel sheet has 10 rows, then the test is executed for 10 times.
Please let me know is there any method or trick to control the iteration by specifying a particular row to execute.