that seems logical.

Excel is pretty persnickety when it comes to holding files open and
I'm pretty sure I've seen a few instances where I wasn't able to move
stuff around on network shares due to the fies being 'open' even
though the user claimed to have closed excel, and we had to reboot
things to free up the file locks.

On Apr 4, 10:12 pm, "vladimir...@hotmail.com"
<vladimir...@hotmail.com> wrote:
> I think it may be useful to someone to read it.
> The problem went away after restarting the computer.
> After analyzing the code, I believe it was caused by the following
> actions.
> Initialy when I experimented with Excel, I made a logical error not
> closing the Excel file in some cases.
> It created multiple instances of Excels.
> I killed all of them using Task Manager.
> Probably, it was not enough. After fixing the error and restarting the
> computer, it works fine.
>
> Regards,
> Vladimir Belorusets,
> SQA Manager, Xerox
>
> On Apr 2, 10:30 pm, "vladimir...@hotmail.com"
>
>
>
> <vladimir...@hotmail.com> wrote:
> > When I reverting back to my initial code, it does not work now .
> > The error occurs while executing startup() function.
> > My test cases start with the following code:
>
> > $: << File.expand_path("c:/watir testware/libraries")
> > require 'setup'
> > startup()
>
> > ----------------------------------------
> > The setup library has the following code:
> > # load all supporting libraries
> > require 'watir'
> > require 'DSlib'
> > require 'general'
> > require 'win32ole'
>
> > def startup
> > # redirect stdout to results file
> >   @orig_stdout = $stdout
>
> >   $base = "http://crisp.adoc.xerox.com:8080/docushare/dsweb/";
> >   $ie = Watir::IE.new   # I believe it fails here
>
> > # get results file name
> >   rfile = str_get_last_element( $0, '/' )
> >   rfile = rfile.split( '.' ).first
> >   $stdout = File.new("c:/watir testware/results/" + rfile + ".txt",
> > 'w')
> >   puts "Inside startup."
> > end
> > ---------------------------------------------------------------------------­­----------------------------
> > The problem happened after I wrote the following innocent code, which
> > works fine:
>
> > def ex_get_value( excel_file, header )
> >   require 'win32ole'
> >   app = WIN32OLE.new( 'Excel.Application' )
> > #  app.Visible = 1
> >   wb = app.Workbooks.Open( "C:/Watir Testware/Scripts/
> > cm_CreateCollectionAsCPXUser.xls" )
> >   ws = wb.Worksheets( 1 )
>
> > # number of used columns in the worksheet
> >   col_total = ws.UsedRange.Columns.Count
> >   for i in 1..col_total do
> >       v = ws.Cells( 1, i ).Value
> >       break if ( v == header )
> >       if i == col_total
> >         puts "No column with #{header} header was found."
> >         app.ActiveWorkbook.Close( 0 )
> >         app.Quit()
> >         return
> >       end
> >   end
>
> >   puts ws.Cells( 2, i ).Value
> >   app.ActiveWorkbook.Close( 0 )
> >   app.Quit()
>
> > end
>
> > ex_get_value( "C:/Watir Testware/Scripts/
> > cm_CreateCollectionAsCPXUser.xls", "password" )
>
> > But now the startup() code stopped working.
> > May be I need to kill some processes?
>
> > Thanks,
> > Vladimir
>
> > On Apr 2, 10:09 pm, Chuck van der Linden <sqa...@gmail.com> wrote:
>
> > > what sort of experimenting were you doing?   what things did you
> > > change during the course of your experiments?
>
> > > have you tried reverting back to the code from before your
> > > experiments, does it work or is it now also broken?. (you are using
> > > source control, or at least keeping backups right?)
>
> > > On Apr 2, 8:19 pm, "vladimir...@hotmail.com" <vladimir...@hotmail.com>
> > > wrote:
>
> > > > My Watir scripts worked fine. But after experimenting with Excel
> > > > files, I'm getting this error.
>
> > > > failed to create WIN32OLE object from `InternetExplorer.Application'
> > > >     HRESULT error code:0x80004005
> > > >       Unspecified error
> > > > C:/Ruby/lib/ruby/gems/1.8/gems/watir-1.6.2/lib/watir/ie-class.rb:
> > > > 167:in `initial
> > > > ize'
>
> > > > It happened at $ie = Watir::IE.new.
> > > > Again it worked before.
>
> > > > Please, help. Very upset.
>
> > > > Vladimir- Hide quoted text -
>
> > > - Show quoted text -- Hide quoted text -
>
> > - Show quoted text -- Hide quoted text -
>
> - Show quoted text -
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"Watir General" group.
To post to this group, send email to watir-general@googlegroups.com
Before posting, please read the following guidelines: 
http://wiki.openqa.org/display/WTR/Support
To unsubscribe from this group, send email to 
watir-general-unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/watir-general
-~----------~----~----~----~------~----~------~--~---

Reply via email to