Re: [Sheflug] Can open office help?

[Alex Hudson <home@xxxxxxxxxxxxxx>]

On Thu, 2007-02-01 at 07:29 +0000, david wrote:
> When the data is exported Excel's now fired up automatically and the
> data appears in a spreadsheet. .... The network manager's looked
> for a temporary excel file on the hard drive but can't find one, and
> the error that comes up on the machines with Office 2000 is something
> like 'The application couldn't be found' - sorry I didn't jot down the
> exact message. Can anyone suggest a way in which OO (or another open
> source solution) might help? 

Well, if there's no temporary file, something very odd is going on. It
could be Excel is sourcing the information directly from SIMS - which
would be interesting - or that SIMS is essentially pasting the
information into Excel.

I think you need to try harder to find where the data is coming from :)

The "worst case scenario" is that SIMS actually loads up the Excel
application, and pushes the data into it: it sounds like a lot of effort
and I don't see why they would have done that, but it's possible.

Possibly, they're using some different system than files. It could be a
web query - search the hard drive for *.iqy files - or they could be
doing something with ODBC. 

I would try opening up the data in Excel again, and try to look in the
Excel information dialogs to see where Excel thinks the data is coming
from.

Obviously, if they're doing it via the Office APIs and pushing data into
it, you're likely stuffed - you'd have to write an automatic Office
macro or something to get the data out again.

Cheers,

Alex.


_______________________________________________
        Sheffield Linux User's Group
  http://wwww.sheflug.org.uk/mailfaq.html
 GNU - The choice of a complete generation