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...@googlegroups.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
