Parsing Form Fields / Checkboxes from Word Docs

gogusrl

Molten Core Raider

1,365

108

• Dec 2, 2015

• #1

Need to extract some checkboxes and do some piecharts with them. Anyone got a tip on where to start ?

Example doc :test.doc - Google Drive

 

Izo

Tranny Chaser

20,043

25,009

• Dec 2, 2015

• #2

Hire a secretary?

 

Palum

what Suineg set it to

29,215

48,949

• 

• Dec 2, 2015

• #3

VBA can do that fairly easily. I don't know what Google docs does for scripting, though.

 

gogusrl

Molten Core Raider

1,365

108

• Dec 2, 2015

• #4

I just used google docs to share the file, everything is gonna be locally.

 

Palum

what Suineg set it to

29,215

48,949

• 

• Dec 2, 2015

• #5

Before you do VBA see if you can use power query for it? Not sure if they have an extension that will parse word doc form elements.

 

ToeMissile

Pronouns: zie/zhem/zer

<Gold Donor>

3,483

2,289

• Dec 3, 2015

• #6

Power query is definitely Excel only.

Didn't read the whole article, but this looks about right.

10 steps to transferring Word form data to an Excel sheet - TechRepublic