Sorry about resurrecting this thread (or trying to, anyway).
I am also having problems in loading (or using) the win32ole module (on a WinXP PC). For those using Macs as I also do, I doubt there is any point in using win32ole. Presumably one would have to find some way of using the Automator or some other form of scripting.
On starting SketchUp, I opened the Ruby Console and listed the extensions (I have used prompt> to indicate the lines that I typed):
prompt> p $"
["examples.rb", "sketchup.rb", "langhandler.rb", "extensions.rb", "LangHandler.rb", "ocean_extension.rb", "utilities.rb", "C;/Program Files/Google/Google SketchUp 7/Plugins/Utilities/utilitiesTools.rb", "dynamiccomponents.rb", "C;/Program Files/Google/Google SketchUp 7/Tools/DynamicComponents/ruby/dcloader.rb", "make_pano_pm.rb", "sandboxtools.rb", "C;/Program Files/Google/Google SketchUp 7/Tools/Sandbox/SandboxMenus.rb", "webtextures.rb", "C;/Program Files/Google/Google SketchUp 7/Tools/WebTextures/webtextures_loader.rb"]
nil
I then tried to load the win32ole module ("win32ole.so"), which I had extracted from the zip file "ruby-1.9.1-p376-i386-mswin32.zip" and had placed in the plugins directory. Note that I did not "install" ruby or do anything other than extract this file.
prompt> require 'win32ole'
Error; #<LoadError; C;/Program Files/Google/Google SketchUp 7/Plugins/win32ole.so; 126; The specified module could not be found. - C;/Program Files/Google/Google SketchUp 7/Plugins/win32ole.so>
(eval);894
It seemed to me that I had therefore failed. I therefore tried a different format (not being sure of the difference between single and double quotes)
prompt> require "win32ole"
false
Now this was strange.. why was I getting a "false" response. Did this mean that win32ole was already loaded...?
prompt> p $"
["examples.rb", "sketchup.rb", "langhandler.rb", "extensions.rb", "LangHandler.rb", "ocean_extension.rb", "utilities.rb", "C;/Program Files/Google/Google SketchUp 7/Plugins/Utilities/utilitiesTools.rb", "dynamiccomponents.rb", "C;/Program Files/Google/Google SketchUp 7/Tools/DynamicComponents/ruby/dcloader.rb", "make_pano_pm.rb", "sandboxtools.rb", "C;/Program Files/Google/Google SketchUp 7/Tools/Sandbox/SandboxMenus.rb", "webtextures.rb", "C;/Program Files/Google/Google SketchUp 7/Tools/WebTextures/webtextures_loader.rb", "win32ole.so"]
nil
prompt> require 'win32ole'
false
Hmmm... it seems that win32ole is loaded, but I never got a message to say that it was being loaded. Can I use it...
prompt> excel = WIN32OLE;;new('excel.Application')
excel = WIN32OLE;;new('excel.Application')
Error; #<NameError; (eval);894; uninitialized constant WIN32OLE>
(eval);894
prompt> print( "excel version; " + excel.version.to_s + "\n")
Error; #<NoMethodError; (eval);894; undefined method `version' for nil;NilClass>
(eval);894
No... it seems not... so what am I doing wrong? I also tried WIN32OLE.new and win32ole.new and neither of them worked. If anyone can help me, I would appreciate it.