Macro to copy OO text to outside program
-
- Posts: 12
- Joined: Tue Apr 08, 2008 8:47 pm
Macro to copy OO text to outside program
I am a doctor working various places. One place has a electronic medical record (actually designed more for college counselors). I keep and write my notes in OpenOffice because I have several useful macros, including writing a prescription, but I need to copy the note to the other program (called Titanium), which involves a lot of clicking. I would like help writing a macro to do this. I already have macros which can find the patient name, make it a variable and use it to find the right place in the other program, but I am not sure how to use macros outside of OO and whether I have to use some other language instead of the one included in OO. Thanks for any help or suggestions.
Re: macro to copy OO text to outside program
The crucial question here is: In which program is the (mouse) clicking required?amurphy96822 wrote: but I need to copy the note to the other program (called Titanium), which involves a lot of clicking.
As long as the "clicking" is in OpenOffice it is very well possible that a macro can do the same with a single click or a single keyboard shortcut. But if the majority of the clicks is made in the other program (Titanium? It is nearly impossible to find something meaningful with a Google search, as Titanium is also a processor architecture of Intel and quite often used for several different kinds of software) you will have to figure out wether this other program supports macro automation and which language you might need for this.
If the "Titanium" program doesn't support macros you may still have a chance if you fall back on the Windows Scripting Host and its VBScript language. Based on the COM Automation bridge OpenOffice can be automated through VBScript and in parallel you can use the rather generic SendKeys functionality automate the other application. This should work if you can achieve what you need by using Alt- or Ctrl-Something keys to activate menu operations instead of using the mouse.
OpenOffice 3.1.1 (2.4.3 until October 2009) and LibreOffice 3.3.2 on Windows 2000, AOO 3.4.1 on Windows 7
There are several macro languages in OOo, but none of them is called Visual Basic or VB(A)! Please call it OOo Basic, Star Basic or simply Basic.
There are several macro languages in OOo, but none of them is called Visual Basic or VB(A)! Please call it OOo Basic, Star Basic or simply Basic.