Selecting strings in a Word document other than URLs and changing font color to red using VBA
I have a word document that has a lot of URLs followed by their descriptions mostly separated by a dash (-) but not always. I would like to write a script in VBA that selects those descriptions (minus dashes if there are any) and changes their font color from black to red. The following is the general pattern (there is a line return at the end of each description and URLs all begin as new lines). Sometimes the description is followed by a simple space (no dash) and sometimes the description is below the URL (new line):
http://www.something1.com - some description 1
...
http://www.something10.com - some description 10
...
http://www.something11.com some description 11
http://www.something12.com some description 12
...
http://www.something13.com
some description 13
http://www.something14.com
some description 14
microsoft-word vba fonts search macros
asked Jan 8 at 9:23
BrunoBruno
11
New contributor
Bruno is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
I have a word document that has a lot of URLs followed by their descriptions mostly separated by a dash (-) but not always. I would like to write a script in VBA that selects those descriptions (minus dashes if there are any) and changes their font color from black to red. The following is the general pattern (there is a line return at the end of each description and URLs all begin as new lines). Sometimes the description is followed by a simple space (no dash) and sometimes the description is below the URL (new line):
http://www.something1.com - some description 1
...
http://www.something10.com - some description 10
...
http://www.something11.com some description 11
http://www.something12.com some description 12
...
http://www.something13.com
some description 13
http://www.something14.com
some description 14
microsoft-word vba fonts search macros
asked Jan 8 at 9:23
BrunoBruno
11
New contributor
Bruno is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Hi and welcome to Superuser. What have you tried yourself? Can you include your (non-working) VBA code in the question?
– Saaru Lindestøkke
Jan 8 at 9:43
I know Autohotkey and Regular Expression but when it comes to Word VBA I am a newbie. I posted this request to get a working code so that I can study, analyze and learn about loop and regular expression as I guess it is implemented in Word VBA in some form as it applies to my question.
– Bruno
Jan 8 at 10:41
1
I posted this request to get a working code, while it's certainly possible someone will come by and solve your problem for you, it's not something the stackexchange community is for. It is best to break down your problem and start researching each part. When you encounter an issue, you can show your work until that point and ask for help.
– Saaru Lindestøkke
Jan 8 at 11:35
add a comment |
I have a word document that has a lot of URLs followed by their descriptions mostly separated by a dash (-) but not always. I would like to write a script in VBA that selects those descriptions (minus dashes if there are any) and changes their font color from black to red. The following is the general pattern (there is a line return at the end of each description and URLs all begin as new lines). Sometimes the description is followed by a simple space (no dash) and sometimes the description is below the URL (new line):
http://www.something1.com - some description 1
...
http://www.something10.com - some description 10
...
http://www.something11.com some description 11
http://www.something12.com some description 12
...
http://www.something13.com
some description 13
http://www.something14.com
some description 14
microsoft-word vba fonts search macros
asked Jan 8 at 9:23
BrunoBruno
11
New contributor
Bruno is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
I have a word document that has a lot of URLs followed by their descriptions mostly separated by a dash (-) but not always. I would like to write a script in VBA that selects those descriptions (minus dashes if there are any) and changes their font color from black to red. The following is the general pattern (there is a line return at the end of each description and URLs all begin as new lines). Sometimes the description is followed by a simple space (no dash) and sometimes the description is below the URL (new line):
http://www.something1.com - some description 1
...
http://www.something10.com - some description 10
...
http://www.something11.com some description 11
http://www.something12.com some description 12
...
http://www.something13.com
some description 13
http://www.something14.com
some description 14
microsoft-word vba fonts search macros
microsoft-word vba fonts search macros
asked Jan 8 at 9:23
BrunoBruno
11
New contributor
Bruno is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked Jan 8 at 9:23
BrunoBruno
11
New contributor
Bruno is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited Jan 8 at 9:28
Bruno
asked Jan 8 at 9:23
BrunoBruno
11
New contributor
Bruno is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked Jan 8 at 9:23
BrunoBruno
11
asked Jan 8 at 9:23
BrunoBruno
11
11
New contributor
Bruno is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Bruno is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Bruno is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Hi and welcome to Superuser. What have you tried yourself? Can you include your (non-working) VBA code in the question?
– Saaru Lindestøkke
Jan 8 at 9:43
I know Autohotkey and Regular Expression but when it comes to Word VBA I am a newbie. I posted this request to get a working code so that I can study, analyze and learn about loop and regular expression as I guess it is implemented in Word VBA in some form as it applies to my question.
– Bruno
Jan 8 at 10:41
1
I posted this request to get a working code, while it's certainly possible someone will come by and solve your problem for you, it's not something the stackexchange community is for. It is best to break down your problem and start researching each part. When you encounter an issue, you can show your work until that point and ask for help.
– Saaru Lindestøkke
Jan 8 at 11:35
add a comment |
Hi and welcome to Superuser. What have you tried yourself? Can you include your (non-working) VBA code in the question?
– Saaru Lindestøkke
Jan 8 at 9:43
I know Autohotkey and Regular Expression but when it comes to Word VBA I am a newbie. I posted this request to get a working code so that I can study, analyze and learn about loop and regular expression as I guess it is implemented in Word VBA in some form as it applies to my question.
– Bruno
Jan 8 at 10:41
1
I posted this request to get a working code, while it's certainly possible someone will come by and solve your problem for you, it's not something the stackexchange community is for. It is best to break down your problem and start researching each part. When you encounter an issue, you can show your work until that point and ask for help.
– Saaru Lindestøkke
Jan 8 at 11:35
Hi and welcome to Superuser. What have you tried yourself? Can you include your (non-working) VBA code in the question?
– Saaru Lindestøkke
Jan 8 at 9:43
Hi and welcome to Superuser. What have you tried yourself? Can you include your (non-working) VBA code in the question?
– Saaru Lindestøkke
Jan 8 at 9:43
I know Autohotkey and Regular Expression but when it comes to Word VBA I am a newbie. I posted this request to get a working code so that I can study, analyze and learn about loop and regular expression as I guess it is implemented in Word VBA in some form as it applies to my question.
– Bruno
Jan 8 at 10:41
I know Autohotkey and Regular Expression but when it comes to Word VBA I am a newbie. I posted this request to get a working code so that I can study, analyze and learn about loop and regular expression as I guess it is implemented in Word VBA in some form as it applies to my question.
– Bruno
Jan 8 at 10:41
1
1
I posted this request to get a working code, while it's certainly possible someone will come by and solve your problem for you, it's not something the stackexchange community is for. It is best to break down your problem and start researching each part. When you encounter an issue, you can show your work until that point and ask for help.– Saaru Lindestøkke
Jan 8 at 11:35
I posted this request to get a working code, while it's certainly possible someone will come by and solve your problem for you, it's not something the stackexchange community is for. It is best to break down your problem and start researching each part. When you encounter an issue, you can show your work until that point and ask for help.– Saaru Lindestøkke
Jan 8 at 11:35
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Bruno is a new contributor. Be nice, and check out our Code of Conduct.
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%2fsuperuser.com%2fquestions%2f1391805%2fselecting-strings-in-a-word-document-other-than-urls-and-changing-font-color-to%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Bruno is a new contributor. Be nice, and check out our Code of Conduct.
Bruno is a new contributor. Be nice, and check out our Code of Conduct.
Bruno is a new contributor. Be nice, and check out our Code of Conduct.
Bruno is a new contributor. Be nice, and check out our Code of Conduct.
Thanks for contributing an answer to Super User!
- 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%2fsuperuser.com%2fquestions%2f1391805%2fselecting-strings-in-a-word-document-other-than-urls-and-changing-font-color-to%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
Hi and welcome to Superuser. What have you tried yourself? Can you include your (non-working) VBA code in the question?
– Saaru Lindestøkke
Jan 8 at 9:43
I know Autohotkey and Regular Expression but when it comes to Word VBA I am a newbie. I posted this request to get a working code so that I can study, analyze and learn about loop and regular expression as I guess it is implemented in Word VBA in some form as it applies to my question.
– Bruno
Jan 8 at 10:41
1
I posted this request to get a working code, while it's certainly possible someone will come by and solve your problem for you, it's not something the stackexchange community is for. It is best to break down your problem and start researching each part. When you encounter an issue, you can show your work until that point and ask for help.– Saaru Lindestøkke
Jan 8 at 11:35