Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old July 6th 13, 11:25 AM
Junior Member
 
First recorded activity by ExcelBanter: Jul 2013
Posts: 1
Default Setting up a word-count inventory for my novel

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 have a manual spreadsheet that works for me, but ideally I would like the data to fly from Word straight into Excel as follows:

1. Enter shortened title into Column A (usually the first line of a chapter or section)
2. Enter the word count of that file into Column C

The total will be calculated by the formula sum(c:c).

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.

I should add, in case it's unclear, I'm referring to the word-counts of individual files. I can't seem to make Windows 7 list the word-counts in Windows Explorer, even though there is a Details column for this purpose. So I'd like Excel to peak inside the document file, read the word-count and the title and add them to the spreadsheet as described above.

Last edited by FretLess : July 6th 13 at 11:35 AM Reason: Clarity, I hope.

  #2   Report Post  
Old July 6th 13, 01:08 PM posted to microsoft.public.excel.newusers
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...


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Setting up Inventory S.H.C New Users to Excel 3 September 24th 08 07:27 AM
INVENTORY CYCLE COUNT IN EXCEL SSJ New Users to Excel 3 March 21st 07 07:16 PM
INVENTORY STOCK COUNT vandy Excel Worksheet Functions 7 December 15th 06 01:20 AM
Folder Inventory & Count for like named files theDude[_19_] Excel Programming 0 August 2nd 05 01:23 AM
add an inventory item to a word doc if there is a Y in column C fitful_thought Excel Programming 2 July 19th 04 01:59 AM


All times are GMT +1. The time now is 09:32 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017