Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-18-2023, 08:48 AM
Kosmosent Kosmosent is offline VBA Excel for word compiler Windows 10 VBA Excel for word compiler Office 2021
Novice
VBA Excel for word compiler
 
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
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA Excel for word compiler Excel gives Normal.dotm: File format is not valid message (yes, Excel, not Word) Windspeed Excel 10 08-03-2022 04:29 PM
Word & Excel 2010 - Best Options To Auto Insert MySQL & Excel Data? Hoser Word 1 03-17-2017 03:47 PM
Embeding Excel Docs in Word - Receiving Memory Error Message if Excel is open kdash Word 0 05-06-2015 09:38 AM
VBA Excel for word compiler Merge From Excel With Table in Word - Next Record If Excel Column Same? misscrf Mail Merge 2 10-15-2014 11:51 PM
VBA Excel for word compiler Open Word w Excel & fill Word textboxes w info from Excel fields runtime error 4248 Joe Patrick Word VBA 2 01-30-2012 07:23 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:01 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2023, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2023 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft