Creating a macro in word to fill out report templates. I manually fill information in excel then copy & paste each cell into corresponding advanced properties place holder text already created in word. Is it possible to write a macro to match names from the word properties text and replace with corresponding values from an excel workbook? I have attached a PDF of exactly how my template works now without a macro. If helpful I could upload the word and excel files that I am trying to force to talk with each other. I have tried the record macro, but I can’t get the macro to do what I want. Any suggestions on where to start would be great!
Red Flag Submitted
Thank you for helping keep Eng-Tips Forums free from inappropriate posts. The Eng-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Eng-Tips forums is a member-only feature.
By implementing a new 3D CAD tool, top-performing manufacturers can reduce their development time by 19 percent and development costs by 15 percent. Most importantly, engineers can increase iterations by 14 percent â€” leading to more innovation and competitive advantages. Download Now