View Single Post
  #2   Report Post  
Old July 6th 13, 01:08 PM posted to microsoft.public.excel.newusers
Stan Brown Stan Brown is offline
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2007
Posts: 524
Default Setting up a chapter a word-count inventory for a novel

On Sat, 6 Jul 2013 11:25:27 +0100, FretLess wrote:
Hi, as per the title, I'm halfway though my first novel and I would like
to automate the process of tracking my cumulative word count.


I would imagine it can be done via some sort of VBA. I've never
written a macro in Word, so I have no idea how hard it may be to use
a macro in Word to update an Excel workbook.

If it's not obvious, when you get into it, how to do that, you might
take a hybrid approach of writing from Word to a text file or a CSV
file, and then have an auto-open macro in your Excel workbook that
reads that file and updates the workbook.

I'm using Office Starter, so perhaps I need a third party work-around, I
don't know. Appreciate some pointing in the right direction.


Hmm ... I don't know whether VBA is even available in that version.
It may not be, in which case you can't automate anything.



--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com
Shikata ga nai...