You know, I had an issue with Excel opening files as well.  I was able to set path to a variable and save the file wherever I wanted, but was not able to open this file again using the same variable, or the same path spelled-out.  I would get an exception saying unable to find (full path and filename), which seemed daft because the full path and filename shown in the error was exactly where the file was.
 
The only time I was able to open files was when I used the default unspecified path, which starts in My Documents.
 
Anyway, here is a great guide on Ruby and Excel:  http://wiki.rubygarden.org/Ruby/page/show/ScriptingExcel


From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Zeljko Filipin
Sent: Monday, August 21, 2006 8:22 AM
To: [email protected]
Subject: Re: [Wtr-general] problem in opening a file

Or you could put path to a variable

path = "
C:\demo\"
workbook = excel.Workbooks.Open ("#{path}mation.xls")

Zeljko
_______________________________________________
Wtr-general mailing list
[email protected]
http://rubyforge.org/mailman/listinfo/wtr-general

Reply via email to