in reply to Re^4: cygwin, make, perl, win32::ole (excel) problem
in thread cygwin, make, perl, win32::ole (excel) problem

Always give absolute filenames to Excel. The "current directory" for an OLE object can very well differ from what your application thinks its current directory is. So if you change filereport.xls to become Y:\In\filereport.xls in your call to $excel->Workbooks->Add() it should work, or fail in a different way.

Replies are listed 'Best First'.
Re^6: cygwin, make, perl, win32::ole (excel) problem
by Bloodnok (Vicar) on Dec 03, 2008 at 15:38 UTC
    Hi Corion,

    Long time, no speak.

    AFAICT (from the generated error message) an absolute path _is_ being passed in - it appears as tho' Excel takes it upon itself to report the error as a relative path - I wondered, as you've no doubt seen, whetehr the containing dir exists with the right perms...

    Update

    self-- ... I got Corions name wrong :-((

    A user level that continues to overstate my experience :-))