excel.Workbooks.Open(''D:\shiv.xls'') - change this line also and make
shiv.xls exist in D-driveOn Thu, Jul 8, 2010 at 6:55 PM, Basim Baassiri <[email protected]> wrote: > 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]<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]
