Hi, I can not understand what problem you guys are facing.
I am also trying to get the value of cell A(1,1) of excel and the value of cell A(1,1) is being calculated by formula "=(B2+C2)" Per my understanding you want to access the value of cell and not the formula which is being applied in that cell.. When I access the cell A(1,1) using vbscript then it is returning me the value and not the formula which is absolutely fine I guess. Please find below screenshot. [image: Inline image 1] [image: Inline image 3] Please let me know if I am unable to get your question. Thanks, Nishant On Fri, Jan 24, 2014 at 8:02 AM, Nik <[email protected]> wrote: > Francois, I think I understand your issue. You need to import the valuees > of excel instead of the formulas? Unfortunately, I do not think that there > is an easy solution. I know i tried it and was not able to do so directly. > But in the qtp world, there is always a solution. May I ask why you want to > import this data? What domyou intend to use it for? I would recommend using > an excel object to do a paste special of only values after you copy them. > So copy all cells, paste special in a new sheet with only values, then > import those values. Bit of a pain, but I havent seen better solutions out > there. > www.qtptutorial.net > > -- > -- > 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 a topic in the > Google Groups "QTP - HP Quick Test Professional - Automated Software > Testing" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/mercuryqtp/pL_6oyufO5E/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > [email protected]. > For more options, visit https://groups.google.com/groups/opt_out. > -- Regards, Nishant Pawar. -- -- 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.
<<image.png>>
<<image.png>>
