C
cgilbert
I am creating an input form in Word 2000 and would like to store the
values input by a user into some kind of spread sheet. I am hoping this
can be done in order to skip manual data entry and instead simply
extract the responses as a column of data.
I've had a few problems with the implementation by Daryl Lucas below:
http://word.mvps.org/FAQs/MacrosVBA/LinkTableWithGraph.htm
I adopted the macro to accept text fields into the MS Graph DataSheet
object. But, when I protect the document, each time I enter data, the
MS Graph DataSheet opens up. What is the code to stop that and maintain
the flow of data entry?
Also, is there a way to hide the actual graph view for the MS Graph
object? Since I'm using text data, I don't want the graph to be seen.
Or should I use an embedded Excel? If so, does anyone have a macro to
copy Form Field text into the Excel table?
Unfortunately, I know nothing about VBA and macro coding and have not
easily found a list of the syntax to figure it out myself. Any help
would be greatly appreciated, thanks.
values input by a user into some kind of spread sheet. I am hoping this
can be done in order to skip manual data entry and instead simply
extract the responses as a column of data.
I've had a few problems with the implementation by Daryl Lucas below:
http://word.mvps.org/FAQs/MacrosVBA/LinkTableWithGraph.htm
I adopted the macro to accept text fields into the MS Graph DataSheet
object. But, when I protect the document, each time I enter data, the
MS Graph DataSheet opens up. What is the code to stop that and maintain
the flow of data entry?
Also, is there a way to hide the actual graph view for the MS Graph
object? Since I'm using text data, I don't want the graph to be seen.
Or should I use an embedded Excel? If so, does anyone have a macro to
copy Form Field text into the Excel table?
Unfortunately, I know nothing about VBA and macro coding and have not
easily found a list of the syntax to figure it out myself. Any help
would be greatly appreciated, thanks.