[users] Scripting help resources

2008-07-11 Thread Phil Hibbs
I've been trying to learn OOo scripting, and so far I've learned a few things by finding examples. For instance, to open a text file and read from it, you have to do something like this: FilePickerDlg = createUnoService( com.sun.star.ui.dialogs.FilePicker ) FilePickerDlg.appendFilter( DSX

Re: [users] Scripting help resources

2008-07-11 Thread Andrew Douglas Pitonyak
Although I did not verify, I believe that you can use commands such as Open importfile For Input As #1 That said, although this may work, you should not use #1 directly, but rather, you should use the FreeFile statement (even in Excel) Dim iNumber As Integer iNumber = FreeFile Open

Re: [users] Scripting

2007-10-29 Thread James Courtier-Dutton
On 26/10/2007, Robin Laing [EMAIL PROTECTED] wrote: mike scott wrote: On 25 Oct 2007 at 11:58, Frank Cox wrote: On Thu, 25 Oct 2007 15:20:07 +0100 James Courtier-Dutton [EMAIL PROTECTED] wrote: How would I get openoffice to do this information abstraction bit of the task? If I

Re: [users] Scripting

2007-10-29 Thread mike scott
... I tried catdoc, but that only dumps the text from the document, not the properties of the document, like who created it, creation date etc. In MS Word these appear on the File-Properties menu. The either the Summary or Custom tags. In Open Office, Insert-Fields-Other The Variables tab,

Re: [users] Scripting

2007-10-26 Thread mike scott
On 25 Oct 2007 at 11:58, Frank Cox wrote: On Thu, 25 Oct 2007 15:20:07 +0100 James Courtier-Dutton [EMAIL PROTECTED] wrote: How would I get openoffice to do this information abstraction bit of the task? If I was you, I wouldn't. I would whip something up with C or Perl or whatever

Re: [users] Scripting

2007-10-26 Thread Robin Laing
mike scott wrote: On 25 Oct 2007 at 11:58, Frank Cox wrote: On Thu, 25 Oct 2007 15:20:07 +0100 James Courtier-Dutton [EMAIL PROTECTED] wrote: How would I get openoffice to do this information abstraction bit of the task? If I was you, I wouldn't. I would whip something up with C or Perl or

[users] Scripting

2007-10-25 Thread James Courtier-Dutton
Hi, I wish to get a bash script to scan a directory and its subdirectory for any msword .DOC files. It will then look in each file for a particular property tag, and retrieve the value and then store in in a simple CVS file containing: path, filename, tag How would I get openoffice to do this

Re: [users] Scripting

2007-10-25 Thread Frank Cox
On Thu, 25 Oct 2007 15:20:07 +0100 James Courtier-Dutton [EMAIL PROTECTED] wrote: How would I get openoffice to do this information abstraction bit of the task? If I was you, I wouldn't. I would whip something up with C or Perl or whatever to do the job directly and wouldn't try to do that

[users] [Scripting] possible to modify a database form field?

2005-04-18 Thread Jens Ansorg
Hi all, Using m92 I have set up a database that connects to a table in mysql. I have created a form in that database that allows me to edit records. I'd like to extend this form a little: I'd like to add a button that executes a function/macro that - gets the currently selected text in a

Re: [users] [Scripting] possible to modify a database form field?

2005-04-18 Thread Andrew Douglas Pitonyak
Jens Ansorg wrote: Hi all, Using m92 I have set up a database that connects to a table in mysql. I have created a form in that database that allows me to edit records. I'd like to extend this form a little: I'd like to add a button that executes a function/macro that - gets the currently selected