My only conclusion is that the file located at D:\shiv.xls does not exist I've tried the following with success (locally on my machine using C: drive) -setting the file to readonly, readonly and hidden -removed all file permissions (deny all)
sorry i couldn't help out Basim On Thu, Jul 8, 2010 at 11:09 AM, Shiv <[email protected]> wrote: > hi, > > d drive is not in network share, it is local drive of my machine > > shiv > > On 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]<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]
