Hi Nidhi,
As uma mahesh & Babji said try the below code,
set XL = createobject("Excel.Application")
Set WB = XL.Workbooks.Open("PathofXL.xlsx")
Set WS = WB.worksheets("Sheet Name")
WS.Cells(1,1).Value = "Ur Value"
XL.Workbooks.save "Path of file .xlsx"
XL.Workbook.close
XL.Quit
Regards,
Sedhu
On Wed, Feb 11, 2015 at 12:11 PM, Babji k <[email protected]> wrote:
>
> On 27 January 2015 at 15:08, Nidhi Sharma <[email protected]> wrote:
>
>> o open it manually and try to edit something in its ce
>
>
> Hi Nidhi greetings, if you are able to open manually it might be a xlsx
> format
> Please verify it once
>
>
>
> Thanks & Regards
> **-Babji.**
>
> --
> --
> 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/d/optout.
>
--
--
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/d/optout.
