DEar, Above script will not work if exel is not installed ,
so better find openoffice automation com object and use it On 1/27/10, Kevin <[email protected]> wrote: > 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...@googlegroups.com> >> > <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]<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 -- 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
