Hi Kevin,
here is the code
Dim sSheet
Set objExcel = CreateObject("Excel.Application")
objExcel.Visible = true
sSheet = xxx
Set objWorkbook3= objExcel.Workbooks.Open("\\xxx.xls")
Set objworksheet3= objWorkbook3.Worksheets (sSheet)
On Fri, Jan 22, 2010 at 12:53 AM, Kevin <[email protected]> wrote:
> Hi Team,
>
> Small Doubt...I searched but not able to find an answer for this...
>
> How to create an object for Open office Spreadsheet in VB Script ????
>
>
>
> Thanks in Advance...
>
> Kevin
>
> --
> 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]<mercuryqtp%[email protected]>
> For more options, visit this group at
> http://groups.google.com/group/MercuryQTP?hl=en
--
Regards,
Kamran
--
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