Should work if you save the document in XLS format.

On Jan 22, 2:45 am, Kevin <[email protected]> wrote:
> Kamran,
>
> I think this code is to create an object for Microsoft Office Excel...
> WIll it work for Open office Spreadsheet too ?
>
> Thanks...
>
> On Jan 22, 12:02 pm, Kamran <[email protected]> wrote:
>
> > 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%2bunsubscr...@googlegrou­ps.com>
> > > For more options, visit this group at
> > >http://groups.google.com/group/MercuryQTP?hl=en
>
> > --
> > Regards,
> > Kamran- Hide quoted text -
>
> > - Show quoted text -

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

Reply via email to