Thanks Kamran...

On Jan 23, 12:46 am, Kamran <[email protected]> wrote:
> Hi Kevin,
>
> This script first creates an excel object then it opens a spreed sheet.
>
> MD
>
>
>
>
>
> On Fri, Jan 22, 2010 at 2:13 PM, Roman <[email protected]> wrote:
> > 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>
> > <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]<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