View Single Post
 
Old 03-18-2023, 08:48 AM
Kosmosent Kosmosent is offline Windows 10 Office 2021
Novice
 
Join Date: Mar 2023
Posts: 2
Kosmosent is on a distinguished road
Default VBA Excel for word compiler

Hoping to get some tips on creating a compiler to populate a word “template” from an excel index.
  • My word “template” is a normal docx that contains a cover page and all level 1 headings (about 60).
  • The folder on the server contains all documents titled by their heading level (5 levels and about 300 docs).
  • My excel Index contains a list of all documents with hyperlinks to their folder location on the server. Each hyperlink has an ActiveX Checkbox next to it.

The idea is to allow the user to check the box for the desired doc. Then the macro will open the “template” and populate it based on True values from the user selections and place it under the appropriate level 1 heading.

I am having trouble getting the code to place it under the appropriate heading. Also, after I inserted all the checkboxes, the file seemed to behave much slower. I was wondering if anyone had tips or could recommend a better approach.

Any help would be appreciated!
Reply With Quote