is the d drive that you are specifying a network share? also, does the file exist with the correct spelling
Basim On Thu, Jul 8, 2010 at 8:08 AM, Shiv <[email protected]> wrote: > Thanks, BUT i get same error, I changed the 2nd line to > > excel = WIN32OLE::new('excel.application') > On Thu, Jul 8, 2010 at 5:09 PM, SMF SMF <[email protected]> wrote: > >> Change 2nd line to as below- >> >> excel = WIN32OLE::new('excel.application') >> >> On Thu, Jul 8, 2010 at 5:00 PM, Shiv <[email protected]> wrote: >> >>> Hello, >>> >>> I am trying to open a excel file and write data, but i m getting runtime >>> error >>> I checked the path is correct >>> new method works fine but open method throws error...can u pls help me >>> figure out this problem >>> >>> *Code:* >>> require 'win32ole' >>> excel = WIN32OLE.new('excel.application') >>> excel.visible = true >>> excel.Workbooks.Open('D:\shiv.xls') >>> excel.range('A1').value = 'Hello, world.' >>> excel.Close >>> excel.Quit >>> >>> >>> *Error:* >>> C:\Ruby\bin>ruby C:\Ruby_Scripts\Ex_open.rb >>> C:/Ruby_Scripts/Ex_open.rb:6:in `method_missing': Open >>> (WIN32OLERuntimeError) >>> OLE error code:800A03EC in Microsoft Office Excel >>> 'D:\shiv.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, m >>> ake sure that the file has not been renamed, moved, or deleted. >>> HRESULT error code:0x80020009 >>> Exception occurred. >>> from C:/Ruby_Scripts/Ex_open.rb:6 >>> >>> Regards, >>> Shiv >>> >>> -- >>> Before posting, please read http://watir.com/support. In short: search >>> before you ask, be nice. >>> >>> You received this message because you are subscribed to >>> http://groups.google.com/group/watir-general >>> To post: [email protected] >>> To unsubscribe: >>> [email protected]<watir-general%[email protected]> >>> >> >> -- >> Before posting, please read http://watir.com/support. In short: search >> before you ask, be nice. >> >> You received this message because you are subscribed to >> http://groups.google.com/group/watir-general >> To post: [email protected] >> To unsubscribe: >> [email protected]<watir-general%[email protected]> >> > > -- > Before posting, please read http://watir.com/support. In short: search > before you ask, be nice. > > You received this message because you are subscribed to > http://groups.google.com/group/watir-general > To post: [email protected] > To unsubscribe: > [email protected]<watir-general%[email protected]> > -- Before posting, please read http://watir.com/support. In short: search before you ask, be nice. You received this message because you are subscribed to http://groups.google.com/group/watir-general To post: [email protected] To unsubscribe: [email protected]
