M
M.P. Frosch
I am working on a VBa application that will have a long series of pages
which ask questions and accumulate information that is then used to generate
a text document. While I am working on the VBA portion, I want to try
things out in order to make sure that formating and the like is correct. I
have placed a series of named bookmarks into my template in the correct
places -- but after I run the VBA application the first time the bookmarks
are all replaced with the inserted text. Short of closing the document and
re-openning the template how do I get around this for troubleshooting.
As a related question, I know that the VBA application will only run if a
document is opened from a template but would like to find a work-around for
the situation in which the user gets halfway through responding to the
application and answering the questions. Is there a way to save the
document back as a partially completed template to be re-opened when the
user returns? If so, how do I track which bookmarks have been replaced and
therefore which userforms should be hidden?
Thanks.
Matthew
which ask questions and accumulate information that is then used to generate
a text document. While I am working on the VBA portion, I want to try
things out in order to make sure that formating and the like is correct. I
have placed a series of named bookmarks into my template in the correct
places -- but after I run the VBA application the first time the bookmarks
are all replaced with the inserted text. Short of closing the document and
re-openning the template how do I get around this for troubleshooting.
As a related question, I know that the VBA application will only run if a
document is opened from a template but would like to find a work-around for
the situation in which the user gets halfway through responding to the
application and answering the questions. Is there a way to save the
document back as a partially completed template to be re-opened when the
user returns? If so, how do I track which bookmarks have been replaced and
therefore which userforms should be hidden?
Thanks.
Matthew