asked on 2/3/2016

how would i do this - put the name of document and its statics into an excel file

how would i go about rather it is powershell, vbscript, autoit (i don't have a compiler for c++ or any language like that)

i'm wanting to parse the file>properties>advanced properties then characters with spaces count into a spreadsheet

so its something like this
title count
jan23-2016 5412

can it be done with powershell? if so how?
or any other scripting language?

Thanks!

Microsoft Excel Scripting Languages Microsoft Word Powershell Microsoft Office

Last Comment

Bill Prew

2/4/2016

DrTribos

2/3/2016

With the Document open or closed?

I'd use VBA for this.

What is the trigger for adding to / updating the spreadsheet?

How many documents? How many people are involved in this?

bbimis

2/3/2016

ASKER

Well I'm wanting to take all documents on desktop and read the filename, then the statistics ad stated above into an excel file. Basically to make an invoice for transcription. . So once they are parsed then the document is moved to a complete folder. I just haven't a clue how to do it and what scripting language to use.

Bill Prew

2/3/2016

Sure, this is doable in a VBScript approach.

What columns do you want in the output file? I would suggest creating it as a comma delimited file, which can then easily be opened in Excel.

I assume Word will be installed on the computer you need to do this on?

~bp

Bill Prew

2/3/2016

And where would you like the output file written to?

~bp

ASKER CERTIFIED SOLUTION

Bill Prew

2/3/2016