Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-26-2023, 11:14 AM
RobiNew RobiNew is offline Problem with Macropod's "Combine Multiple Word Documents" Windows 10 Problem with Macropod's "Combine Multiple Word Documents" Office 2016
Competent Performer
Problem with Macropod's "Combine Multiple Word Documents"
 
Join Date: Sep 2023
Posts: 183
RobiNew is on a distinguished road
Default Problem with Macropod's "Combine Multiple Word Documents"

Macropod's "Combine Multiple Word Documents" is indeed a precious macro for anyone needing to combine muliple documents. With some (slight) modifications it works very well also for combining HTML files. But I'm having trouble with it in this situation: the files to be combined appear in alphabetical order, but on the disc the order is different, so that in the "Combined" file the appropriate order is lost. I wonder if anyone might have some idea as to how to resolve this problem. Thanks!

Last edited by Charles Kenyon; 12-30-2023 at 08:33 AM. Reason: added link
Reply With Quote
  #2  
Old 12-30-2023, 08:31 AM
Charles Kenyon Charles Kenyon is offline Problem with Macropod's "Combine Multiple Word Documents" Windows 11 Problem with Macropod's "Combine Multiple Word Documents" Office 2021
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,140
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

Quote:
Originally Posted by RobiNew View Post
Macropod's "Combine Multiple Word Documents" is indeed a precious macro for anyone needing to combine muliple documents. With some (slight) modifications it works very well also for combining HTML files. But I'm having trouble with it in this situation: the files to be combined appear in alphabetical order, but on the disc the order is different, so that in the "Combined" file the appropriate order is lost. I wonder if anyone might have some idea as to how to resolve this problem. Thanks!
Consider renaming your documents to be combined, adding a number at the start of each name with sufficient digits so that all documents have the same number of digits. i.e.,
01 **
02 **

10 **
11 **
Reply With Quote
  #3  
Old 12-30-2023, 08:50 AM
RobiNew RobiNew is offline Problem with Macropod's "Combine Multiple Word Documents" Windows 10 Problem with Macropod's "Combine Multiple Word Documents" Office 2016
Competent Performer
Problem with Macropod's "Combine Multiple Word Documents"
 
Join Date: Sep 2023
Posts: 183
RobiNew is on a distinguished road
Default

Thank you, Charles! I did try even that, but it didn't work. I checked the disc and there they were: 01, 02, 03, 04, 05, 06, 07 (but the order was still different: 01, 03, 04, 05, 06, 07, 02). The only explanation in my case seems to be that 02 was added to the folder later than the others. So I tried to copy each file to another dir in the correct order, but to no avail. Nr 02 is very large, the largest of them all.
Reply With Quote
  #4  
Old 01-04-2024, 12:29 PM
Charles Kenyon Charles Kenyon is offline Problem with Macropod's "Combine Multiple Word Documents" Windows 11 Problem with Macropod's "Combine Multiple Word Documents" Office 2021
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,140
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

You may want to put developing this aside and use Boiler - Insert a selection of documents by Graham Mayor, MVP.
Reply With Quote
  #5  
Old 01-04-2024, 02:44 PM
RobiNew RobiNew is offline Problem with Macropod's "Combine Multiple Word Documents" Windows 10 Problem with Macropod's "Combine Multiple Word Documents" Office 2016
Competent Performer
Problem with Macropod's "Combine Multiple Word Documents"
 
Join Date: Sep 2023
Posts: 183
RobiNew is on a distinguished road
Default

Thank you, Charles. I do appreciate your reply and I think that Mayor's Boiler can be really useful, but what I need is macro, however complex. So I will carry on my experiments.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem with Macropod's "Combine Multiple Word Documents" Combine Multiple Word Documents macropod Word VBA 0 09-04-2019 12:09 AM
typing "scr" and problem with "extending selection" danielmatt Word 16 07-21-2019 12:31 PM
extract email from google search "help" please " i can pay no problem after test" mohamedabdu Excel Programming 1 08-22-2018 07:43 PM
Combine "sort within groups" and "identify duplicate/unique values" in two different variables. civilcervant Excel 3 06-12-2017 07:27 AM
Problem with Macropod's "Combine Multiple Word Documents" a problem with the "Documents" folder location in VBA !! ximpostor Word VBA 2 10-12-2012 12:38 PM

Other Forums: Access Forums

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


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