:), thank you, Tiffany, I check my gem local list, I found all the gems version are newer than yours. I always update them and uninstall the old version.
Thanks. Wesley Chen. For life, the easier, the better. On Sun, Dec 6, 2009 at 8:53 AM, Tiffany Fodor <tcfo...@comcast.net> wrote: > Oops, sorry about that - I meant the win32-api gem. > > Actually, I just checked to see what I have and I have a boatload of > windows gems: > > win32-api (1.4.0, 1.1.0, 1.0.6) > win32-clipboard (0.4.1) > win32-dir (0.3.1) > win32-eventlog (0.4.3) > win32-file (0.5.3) > win32-file-stat (1.2.3) > win32-process (0.6.0, 0.5.9, 0.5.8, 0.5.1) > win32-sapi (0.1.3) > win32-sound (0.4.0) > windows-api (0.3.0, 0.2.3) > windows-pr (1.0.2, 0.8.7, 0.8.5, 0.6.2) > > -Tiffany > > On Dec 5, 5:49 pm, Tiffany Fodor <tcfo...@comcast.net> wrote: > > Hey Wesley! > > > > Since you're not getting an error that says there is no method 'range' > > for a nil value, it doesn't seem your problem is data related. Have > > you tried re-installing the Win32ole gem? (just a guess....) > > > > -Tiffany > > > > On Dec 5, 1:17 am, Wesley Chen <cjq....@gmail.com> wrote: > > > > > Thanks, Ethan, > > > I have searched a lot in google. > > > I just want to ask anybody who has met this kind of problem. > > > I think in the group, there are many experts who are good at excel > class. > > > > > Thanks. > > > Wesley Chen. > > > For life, the easier, the better. > > > > > On Sat, Dec 5, 2009 at 3:36 PM, Ethan <notet...@gmail.com> wrote: > > > > Does this have anything to do with Watir? > > > > > > @worksheet seems to be a win32ole corresponding to something in > excel, > > > > which isn't what watir deals with. it's not very clear from the code > snippet > > > > (and screenshots of code are not a good way to convey information - > just > > > > copy and paste) what this is, but it doesn't appear to be using > watir. > > > > > > If this same script was working before, my only advice is the usual > stuff > > > > to try of rebooting, reverting any changes to the system that have > been > > > > made, and googling the error code to see if any results look > informative. > > > >http://www.google.com/search?q=800a01a8 > > > > > > On Sat, Dec 5, 2009 at 02:13, Wesley Chen <cjq....@gmail.com> wrote: > > > > > >> The report always runs OK before, but today, it displays unexpected > error > > > >> message as below: > > > > > >> *E:/NetbeansProjects/qa-test-scripts/Coach > > > >> tool/training/Workout/../../../lib/reporting.rb:178:in > `method_missing': > > > >> range (WIN32OLERuntimeError) > > > >> OLE error code:0 in <Unknown> > > > >> <No Description> > > > >> HRESULT error code:0x800a01a8* > > > > > >> The method is as below: > > > >> *def pages_visited() > > > >> url_cleanup() > > > >> i = 0 > > > >> @worksheet.range("d"+ (10+total_tests()).to_s)['Value'] = > ["Pages > > > >> Visited"] > > > >> @worksheet.range("d"+ > (10+total_tests()).to_s).HorizontalAlignment > > > >> = WIN32OLE::XlCenter > > > >> @worksheet.range("d"+ > > > >> (10+total_tests()).to_s).Interior['ColorIndex'] = 11 > > > >> @worksheet.range("d"+ > (10+total_tests()).to_s).Font['ColorIndex'] > > > >> = 2 > > > >> @worksheet.range("d"+ (10+total_tests()).to_s).Font.Bold = > true > > > >> @urls.each do |page| > > > >> @worksheet.range("d"+ (i+11+total_tests()).to_s).Value = > > > >> [page] > > > >> i += 1 > > > >> end > > > >> end* > > > > > >> Please see the two pictures attached for details. > > > >> code.png means the code; > > > >> ouput.png means the output result. The output result is as expected. > > > > > >> Thanks. > > > >> Wesley Chen. > > > >> For life, the easier, the better. > > > > > >> -- > > > >> 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 > > > > > > -- > > > > 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 > > -- > 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 > -- 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