From: Martin Stannard <martin@...>
Date: 2002-08-01T15:10:07+09:00
Subject: win32ole and excel

Hi,

I'm trying to open a file using win32ole in excel:

    @app = WIN32OLE.new("excel.application")
    @app.visible = true
    template = "racetemplate.xls"
    @book = @app.Workbooks.Open(template)
    @sheet = @book.Worksheets(1)
 
results in the following error:

(druby://127.0.0.1:9001) ./excelmaker.rb:85:in `method_missing': Open
(WIN32OLERuntimeError)
    OLE error code:800A03EC in Microsoft Excel
      'racetemplate.xls' could not be found. Check the spelling of the file
name, and verify that the file location is correct.

If you are trying to open the file from your list of most recently used
files on the File menu, make sure that the file has not been renamed, moved,
or deleted.

    HRESULT error code:0x80020009
      Exception occurred
        from (druby://127.0.0.1:9001) ./excelmaker.rb:85:in `makeSheet'
	etc.....

Has anyone got a sample of loading an xls or xlt template into Excel via
win32ole?

regards,

Martin