Thanks Arunabh.. I did not noted this . It is working now. Once again thanks a lot.
On Wednesday, September 11, 2013 4:26:11 PM UTC+5:30, Arunabh Ray wrote: > > use this: > > Option Explicit > Dim url,xlpath,sheet,opage,*browser1* > Dim i,xl,mysheet,row,vloan,vrate,vterm,vdate,vptax,vPMI,voput,loan > i=2 > vloan = "77777" > > > url="http://www.mortgagecalculatorplus.com/"; > *browser1*="iexplore.exe" > xlpath="C:\Users\satsingh\Desktop\Demo\Testdata" > sheet= "TestData" > systemutil.Run *browser1*,url > Browser("Mortgage Calculator").Page("Mortgage > Calculator").WebEdit("param[principal]").Set > vloan > > You were setting the identifier to a variable so it was throwing the > error. Change it to something else and it will work. > > > > > > On Wed, Sep 11, 2013 at 1:26 PM, uma mahesh <[email protected]<javascript:> > > wrote: > >> Hello, >> >> try to use the below code: >> >> Set xl=CreateObject ("Excel.Application") >> Set XLWB=xl.Workbooks.Open(xlpath) >> Set mysheet=XLWB.WorkSheets(Sheet1) >> row=mysheet.usedrange.rows.count >> >> >> and put the variable in () check the above method and let me know the >> error message you are getting. >> >> Regards >> Uma Mahesh >> >> -- >> -- >> 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]<javascript:> >> To unsubscribe from this group, send email to >> [email protected] <javascript:> >> 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 Groups >> "QTP - HP Quick Test Professional - Automated Software Testing" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected] <javascript:>. >> For more options, visit https://groups.google.com/groups/opt_out. >> > > > > -- > Regards > > Arunabh Ray > -- -- 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 Groups "QTP - HP Quick Test Professional - Automated Software Testing" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
