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
Shikata ga nai...