On Sat, 2006-05-27 at 16:00 +0800, aslay-acme wrote: > Hi All, > > My company is using third party accounting software, the software has > a function to generate reports in MS excel format and automatically > activate MS excel to display the report.
This is done by creating an DDE/OLE (or similar) link from the 3rd party software (the server) to Excel (the client) and pumping VBA commands and the relevant data into Excel. I have written several custom commercial software packages that do this. > After replacing the MS office with Openoffice, the function no longer > working because MS excel can not be found. Because of this problem, I > have no choise but roll back to MS office Not surprising, since the communication link to Excel isn't there and the 3rd party vendor is relying exclusively on Excel and nothing but Excel to achieve this feature of his software. The 3rd party's software is communicating by way of VBA commands and Calc uses Star Basic commands. Considering the above explanation, let's say I write a program which predicts (in advance, with 100% accuracy) the winner of every horse race in the world and outputs the results by exclusively linking to OOo Calc and only Calc using Star Basic. Question: Why would my program not work with MS Excel? > Is there anyway we can do so that the application will activate > openoffice calc ? of course whithout modifying the applcation codes The short answer to your question is: No, not unless the 3rd party software producer modifies his code to communicate with Calc. My recommendation is for you to contact your 3rd party software producer and request this feature be added to his application. In view of the ever increasing popularity of OOo and a growing demand for open standard (non-propriety) file formats, you may be the first of many who will request this feature from him. I hope this sufficiently answers your question. Dave --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
