objExcel.Workbooks.Add - You are trying to add workbook or work sheet?
On Thu, Jan 22, 2015 at 6:00 PM, Nidhi Sharma <[email protected]>
wrote:
> Hi,
>
> I got stuck to 1 problem,please help me to solve this.
>
> If I try to open an excelsheet using VB script code ,I am unable to open
> it.
> Below is the code.
>
> Set objExcel = CreateObject("Excel.Application")
> Set objWorkbook = objExcel.Workbooks.Open("C:\Test\Book1.xls")
>
> objExcel.Application.Visible = True
> objExcel.Workbooks.Add
> objExcel.Cells(1, 1).Value = "Test value"
>
> objExcel.ActiveWorkbook.Save "C:\Test\Book1.xls"
> objExcel.ActiveWorkbook.Close
>
> objExcel.Application.Quit
>
> But when I try to open it manually I am able to open it and also able to
> save the text in the workbook cell which I am unable to do currently,not
> even able to put any value in workbook cell.
>
> Thanks,
> Nidhi Sharma
>
> --
> --
> 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.
>
--
Regards,
Ganesh Muralidharan
'God Never Forgets'
--
--
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.
