I need a word VBA Macro which does the following:
from a selection of a text ("this is a test sentence.") within word:
extract the first three words as an array
call excel from within word, open a new excel spreadsheet and write the three words in the spreadsheet:
macro is started from Word. an excel file is open on the system. the spreadsheet contains:
the word macro does the following:
check if an excel sheet is open. if not: error message box. end macro.
if excel sheet is open:
the word macro reads out the excel sheet.
it inserts the content of the A-column into Word. Where the respective B-column has the value '1' the text is set *bold* in word.
result in word: the following text is added to the document from the excel sheet (between "*" is bold):
"from *excel* to *word*"
to confirm you read the description please include "code: green duck" in your bid/personal message. thanks!
code: green duck Hello, I have experience with similar projects. I am proficient with MS Office and VBA and would love to help. Please contact me for more information.