VBA to parse through a MS-Word doc and modify font of proceeding range with font specified at the top of...
up vote
-1
down vote
favorite
I have a word document containing a table w/ each cell containing a font value and a proceeding string to which I would like to apply that font. In each cell, the font to be applied to the proceeding text appears with "asterisk [FontName] asterisk"
The idea is to have a Macro/VBA which reads in the font value and applies that font to the proceeding block of text within the cell. Then reads in the next cell's font value and applies it to the next block of text. The idea being to repeat this pattern to the end of the doc changing all cell values to the fonts specified at the top of the cell.
The image included shows the starting state and the desired end state. I manually modified these fonts in the end-result to illustrate the desired end-state. In practice, this would be used for a larger document with many more cells/values.
vba fonts ms-word
add a comment |
up vote
-1
down vote
favorite
I have a word document containing a table w/ each cell containing a font value and a proceeding string to which I would like to apply that font. In each cell, the font to be applied to the proceeding text appears with "asterisk [FontName] asterisk"
The idea is to have a Macro/VBA which reads in the font value and applies that font to the proceeding block of text within the cell. Then reads in the next cell's font value and applies it to the next block of text. The idea being to repeat this pattern to the end of the doc changing all cell values to the fonts specified at the top of the cell.
The image included shows the starting state and the desired end state. I manually modified these fonts in the end-result to illustrate the desired end-state. In practice, this would be used for a larger document with many more cells/values.
vba fonts ms-word
add a comment |
up vote
-1
down vote
favorite
up vote
-1
down vote
favorite
I have a word document containing a table w/ each cell containing a font value and a proceeding string to which I would like to apply that font. In each cell, the font to be applied to the proceeding text appears with "asterisk [FontName] asterisk"
The idea is to have a Macro/VBA which reads in the font value and applies that font to the proceeding block of text within the cell. Then reads in the next cell's font value and applies it to the next block of text. The idea being to repeat this pattern to the end of the doc changing all cell values to the fonts specified at the top of the cell.
The image included shows the starting state and the desired end state. I manually modified these fonts in the end-result to illustrate the desired end-state. In practice, this would be used for a larger document with many more cells/values.
vba fonts ms-word
I have a word document containing a table w/ each cell containing a font value and a proceeding string to which I would like to apply that font. In each cell, the font to be applied to the proceeding text appears with "asterisk [FontName] asterisk"
The idea is to have a Macro/VBA which reads in the font value and applies that font to the proceeding block of text within the cell. Then reads in the next cell's font value and applies it to the next block of text. The idea being to repeat this pattern to the end of the doc changing all cell values to the fonts specified at the top of the cell.
The image included shows the starting state and the desired end state. I manually modified these fonts in the end-result to illustrate the desired end-state. In practice, this would be used for a larger document with many more cells/values.
vba fonts ms-word
vba fonts ms-word
edited Nov 8 at 5:37
Cindy Meister
13.4k101934
13.4k101934
asked Nov 8 at 4:53
Keri
155
155
add a comment |
add a comment |
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53201745%2fvba-to-parse-through-a-ms-word-doc-and-modify-font-of-proceeding-range-with-font%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown