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]> 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]
> 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.
>
--
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.
