Link to home
Create AccountLog in
Avatar of bbimis
bbimis

asked on

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!
Avatar of DrTribos
DrTribos
Flag of Australia image
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?
Avatar of bbimis
bbimis

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.
Avatar of Bill Prew
Bill Prew
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
Avatar of Bill Prew
Bill Prew
And where would you like the output file written to?

~bp
ASKER CERTIFIED SOLUTION
Avatar of Bill Prew
Bill Prew
Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer
Avatar of bbimis
bbimis

ASKER

wow, this will do the trick. You happen to know any good books to learn vbscript  or online resources?
Avatar of Bill Prew
Bill Prew
I do have a few links and will share them with you shortly, headed out just now...

~bp