Well, if they are all in a given directory, it would speed things up a bit if the script was executed and just put the values in a text file for import into RBase. The problem with returning the character count one file at a time via WinUDF is each time the script is called, two objects are created, one being an instance of Word (even though you wouldn't see it on the screen) and the Characters.Count property is read and sent back to RBase. The round trip per file is about 2.5 seconds. If you have 50,000 files ........ If the script is executed and the instance of word is started and that single instance opens, gets the count, closes, etc, the process would be many times faster. If all your Word documents are properly named with the ".doc" extension, the text file option would be the best. It would be a CSV file like:
SomeFullPathName.doc,n where SomeFullPathName might be 'f:\word\MyWordDocument.doc' and n might be 2321. Time is short today. I am leaving for a couple of weeks, but, depending on which way you want to go (Like I said in the other post, I have the single version working) I may finish it today or when I get to my destination this weekend... ----- Original Message ----- From: "Thom Cimicato" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Thursday, February 20, 2003 12:08 PM Subject: [RBASE-L] - Re: Developer Wanted!! > I have rbase code that I wrote that will get all the filenames in a given > directory and load them into a temporary table. I can then cursor through > the table. What would be the RBase command to execute your program and how > does it give me the character count back for that particular file? > > Thom > > At 11:22 AM 02/20/2003 -0500, you wrote: > >I have this working. Are all your documents in one directory? How do you > >plan to iterate through the list of documents in your RBase Code? > > > >----- Original Message ----- > >From: "Thom Cimicato" <[EMAIL PROTECTED]> > >To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> > >Sent: Thursday, February 20, 2003 9:47 AM > >Subject: [RBASE-L] - Re: Developer Wanted!! > > > > > > > Yes ASCII characters only. This sounds like it might work but I don't have > > > a clue how to write VBScript or even where to begin. I am looking for > > > someone who can write whatever script/udf/exe/VBScript that would count > >the > > > characters in the file and return the value to RBase. Is this something > >you > > > know how to do? > > > > > > Thom > > > > > > At 09:37 AM 02/20/2003 -0500, you wrote: > > > >Do you mean Ascii Characters only. The Characters Collection of the Word > > > >Document Object has the Count property which gives you the character > >count. > > > >You can do this very simply with WinUDF. > > > > > > > >This is the Characters definition from Word Help: > > > > > > > >Characters Property Example > > > > > > > >This example displays the first character in the selection. If nothing is > > > >selected, the character immediately after the insertion point is > >displayed. > > > > > > > >char = Selection.Characters(1).Text > > > >MsgBox "The first character is... " & char > > > >This example returns the number of characters in the first sentence in > >the > > > >active document (spaces are included in the count). > > > > > > > >numchars = ActiveDocument.Sentences(1).Characters.Count > > > > > > > > > > > >You would create a VBScript to automate word, passing in the document > > > >PathName to process..... > > > > > > > > > > > > > > > >----- Original Message ----- > > > >From: "Thom Cimicato" <[EMAIL PROTECTED]> > > > >To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> > > > >Sent: Wednesday, February 19, 2003 11:55 PM > > > >Subject: [RBASE-L] - Developer Wanted!! > > > > > > > > > > > > > I need a special DLL/UDF or .EXE program for a RBG7 program to get the > > > > > character count of a MS Word file. I am willing to pay to have this > >done > > > >so > > > > > I am looking for a developer that can create this for me. > > > > > > > > > > Interested parties please contact me at [EMAIL PROTECTED] > > > > > 1-800-338-0676 > > > > > > > > > > Warmest Regards, > > > > > > > > > > Thomas Cimicato > > > > > > > > > > --- RBASE-L > > > > > ================================================ > > > > > TO POST A MESSAGE TO ALL MEMBERS: > > > > > Send a plain text email to [EMAIL PROTECTED] > > > > > > > > > > (Don't use any of these words as your Subject: > > > > > INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, > > > > > REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) > > > > > ================================================ > > > > > TO SEE MESSAGE POSTING GUIDELINES: > > > > > Send a plain text email to [EMAIL PROTECTED] > > > > > In the message SUBJECT, put just one word: INTRO > > > > > ================================================ > > > > > TO UNSUBSCRIBE: > > > > > Send a plain text email to [EMAIL PROTECTED] > > > > > In the message SUBJECT, put just one word: UNSUBSCRIBE > > > > > ================================================ > > > > > TO SEARCH ARCHIVES: > > > > > Send a plain text email to [EMAIL PROTECTED] > > > > > In the message SUBJECT, put just one word: SEARCH-n > > > > > (where n is the number of days). In the message body, > > > > > place any > > > > > text to search for. > > > > > ================================================ > > > > > > > > > > > > > > > > Thomas J Cimicato > > > President > > > Integrated Check Technologies > > > Collect-A-Check, Inc. > > > ------------------------------------------------------------ > > > Bus:800.338.0676 > > > Mailto:[EMAIL PROTECTED] > > > www.ICheckTech.com > > > > > > > >
