Use adodb object connection and recordset Objsheet.open "provider=Microsoft.jet.oledb.4.0;data source=xlsdoc.xls;extended properties=""excel 8.0;hdr=yes;"";"
On May 11, 2012, at 1:53 PM, Swapnadeep <[email protected]> wrote: > I know that we can do it using > DataTable.Import > DataTable.ImportSheet > > But it doesnot change the Sheet Name ... > > We can do that only using the Settings->Resources->DataTable -> Other Location > > But if we want to do it at runtime? > -- > You received this message because you are subscribed to the Google > "QTP - HP Quick Test Professional - Automated Software Testing" > group. > To post to this group, send email to [email protected] > To unsubscribe from this group, send email to > [email protected] > For more options, visit this group at > http://groups.google.com/group/MercuryQTP?hl=en -- You received this message because you are subscribed to the Google "QTP - HP Quick Test Professional - Automated Software Testing" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/MercuryQTP?hl=en
