AutomateIT! is an open-source solution called to meet budgetary and business needs of primarily small and mid-sized companies. It automates the integration of OpenOffice with your existing software which exports reports or other data to Microsoft Office; therefore helps you optimize the costs on office automation and serves as an additional argument for switching to OpenOffice.
After AutomateIT! installationyour financial, accounting or other specific office applications that export data to Microsoft Office applications will be exporting them to OpenOffice instead, all this without any changes to your software.
Thus, if you wish to cut IT spending, if you've learned the benefits of OpenOffice and would like to switch from Microsoft Office, AutomateIT! may be a helpful tool for you.
A kind of clones of COM objects of Microsoft Office are being created - the objects themselves and function bodies are being replaced with new ones, which work with OpenOffice.
Tools we used while working on this project: Visual Studio 2003 and OLE/COM object viewer, Regmon for preliminary research.
Log creation is added. Now if user has some problems when exporting data than he can send log file to the Support and it will be fixed. Log is saved to the directory where AutomateIT! is installed.
Bugs with ExcelClone and WordClone are fixed.
Version has passed check on compatibility with such program as «Налогоплательщик ЮЛ».
Why you didn't implement the support of all Microsoft Office functions/methods/classes?
The creation of AutomateIT! had been inspired by a proof-of-concept program provided to Applianz Technologies, Inc. (http://www.applianz.com) and for this reason the product has limited functionality. However, we solved the most complex tasks. As people on the official OpenOffice forum said,
So you don't have the source code for [accounting application]? It's just a compiled .exe ? Well then there is nothing that you can do about it.
If I understand correctly, you want an application that is written to use the COM model to call Microsoft Office to use exactly that same API to call OpenOffice. If this is the case, then the answer is no.
I've got the error message: "...". What does it mean?
There is a variety of reasons. "The server threw an exception" message can sometimes mean that support of currently called function/method/class isn't implemented in AutomateIT! yet. But this is only one of possible reasons. Please contact us in case of any problems or refer to your programmer or system integrator for help.
Should I make changes into my office/accounting applications, which export reports in Microsoft Office, in order to use your product?
No, you don't have to change something. All you need is just OpenOffice and AutomateIT! installed, but you probably have to adjust the last one to your needs. A programmer or system integrator can do this.
Can I redesign your product?
Of course. You always can download the latest release from the SourceForge.net page of our product. AutomateIT! has been released under the LGPL license, so please keep it.
A person with OpenOffice SDK knowledge, as well as COM and C/C++ will be able to improve the product.
I can't adjust your product to my needs. Can you help me?
Feel free to contact us at
if you have any questions. We will be glad to help you.
Microsoft Office is a registered trademark of Microsoft Inc. OpenOffice is a registered trademark of Sun Microsystems Inc. and OpenOffice.org. SourceForge.net is a registered trademark of OSTG, Inc. in the United States and other countries.
Products 
