Re: [Condor-users] Location of Execution files

[Ben Burnett <burnett@xxxxxxxxxxx>]

Stefan:

Have you tried taking the filename onto the end of the buffer 
filled by GetCurrentDirectory()?

Regards,
-B

> -----Original Message-----
> From: condor-users-bounces@xxxxxxxxxxx [mailto:condor-users-
> bounces@xxxxxxxxxxx] On Behalf Of Stefan Tomasiewicz
> Sent: Tuesday, March 17, 2009 2:23 PM
> To: Condor-Users Mail List
> Subject: Re: [Condor-users] Location of Execution files
> 
> Hi Ian
> 
> I had misinformed you before, its not a simple "myFile.open(Excel.xls)"
> however it requires the Windows COM API, the command is:
> "pBook = xl->Workbooks->Open("Excel.xls")"  As this allows me to open
> the spreadsheet within and instance of Excel.
> 
> I have tried ".\Excel.xls", ".\\Excel.xls", "..\\Excel", "\." and even
> just leaving it as the file itself, hoping that it would point to the
> current directory. But they all throw the COM error:
> 
> "Oops - hit an error!
>  Code = 800a03ec
>  Code meaning = Unknown error 0x800A03EC  Source = Microsoft Office
> Excel  Description = '.\Excel.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, make sure that the file has not been renamed, moved, or deleted.
> "
> 
> 
> This leads me to believe that it is the Excel COM API which is trying
> to access the file, so the shorthand might not be applicable. In most
> examples I have seen the file has been opened using a hard coded string
> including the full directory, so it might not be possible. Still trying
> though.
> 
> All help has been much appreciated, I won't be giving up, And should I
> find a solution I will let you know :)
> 
> Cheers,
> Stefan