Bookmarking in Word

[termeric]

Hello,

i'm trying to figure out how i can use VB to bookmark blocks of text in word. i'll be using this macro to book markcertain questions in a questionnaire that i will then send out to some one else to work on, by pulling the bookmarks into an excel spreadsheet.

what i think i want to do is to have the bookmark named after the document and then iterate a number after it. so in general.doc my bookmarks would be listed as general1, general2, general3. financial.doc would have financial1, financial2, financial3, etc...

ive been playing with the macro recorder, but so far ive only been successful in moving around a bookmark, but not actualy creating more than one.

has anyone does somehtign similar to this in the past?

any help or suggestgions on where to start are greatly appreciated.

 

[Macropod]

Hi termeric,

If you set your questionaire up as a form using formfields (eg text formfields for typed answers and drop-down formfields for multiple-choice answers), and protect the document for forms (necessary for the formfields to 'work'), then you can easily extract the data via 'Save data for forms' (under Tools|Options|Save) or via a macro that interrogates the formfields.

Altough you could use the formfields' bookmark names in a macro, you don't need to - simply knowing their order in the document would be enough.

Cheers

 

[termeric]

Hi Macropod, i get the questionnare in from the customer, so im not the one writing them. then i assign out portions to people to complete. would i be able to use formfields to track what work was assigned out to who? would it also interface well with Excel? i need to be able to provide reports to my boss regarding the accuracy and legnth of time it took to complete.

thanks!

 

[Macropod]

Hi termeric,

So who issues the questionaire - someone in your organisation? If so, discuss with the the prospect of having them set it up with formfields,

Formfields probably wouldn't help much with your tracking issue - they're just a convenient means of extracting certain data (eg answers) from a document designed as a form.

In a survey I helped set up using formfields, there were over 300 questions and 150 respondents. Most of the questions were in formfields, but we also provided numerous unprotected Sections at specific points in the document to allow users more flexibility. By having a tightly-managed structure, we were able to collate all the responses into an Excel workbook for analysis. So yes, it can be done, but I didn't need to contend with the survey being split up and different parts responded to by different areas.

Cheers

 

[termeric]

we work with a dozen or more brokers who send us the questionnaires, so we cant really mandate a structure to them. so i'm not creating the questionnaires, just sending off to different people who can answer parts of it, and then compiling everyones responses at the end.

im a project manager.

 

[Macropod]

Hi termeric,


In that case, I don't think there's much you can do to improve productivity in this area.

Since you have no control over the format of the questionaires and each one you receive is going to lack the features you might want to automate extraction of the questions/responses, setting every questionaire up for this is probably going to cost as much time as it'll save - maybe more - especially if the respondents don't complete the questionaires exactly as you want. Bookmarks are fragile things and are all too easily deleted by accident.

Cheers

 

[termeric]

do you think settign up bookmarks to just pull things form word to excel is a waste of time? we are already have a macro that bookmarks and highlights selected text on the click of a button.

 

[Macropod]

Hi termeric,

If you can select & bookmark the desired blocks of text, then why not simply select & export the answers after the survey has been completed? It seems to me that it would be just as quick - and isn't prone to users inadvertently deleting the bookmarks.

Or am I missing something here?

Cheers

 

[termeric]

what do you mean by exporting? it could be me that is missing somehting.

 

[Macropod]

Export: Send from Word to Excel.

If you set up a suitable macro, you could simply select a block of text in Word and have the macro copy it to a cell in Excel.

Cheers