Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #6  
Old 02-20-2012, 08:47 PM
macropod's Avatar
macropod macropod is offline Strange VBA ListTemplate ListLevel Problem Windows 7 64bit Strange VBA ListTemplate ListLevel Problem Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,359
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Hi tinfanide,

See attached. I've fixed the code - plus I declared a couple of undecalred variable and re-formatted the code for legibility. You would do well to manage your own code this way, as it makes the structure much easier to follow. The fix involved telling Word specifically whether to restart or continue the numbering. I also replaced a few unnecessary loops with Repeat statements.

Your code also contains numerous blocks of repeated procedures. These could be turned into one or two separate subs, which your main procedure would then call as needed. Your Word automation could also be made to un much faster by turning screen updating off for the duration of the document's update. Even more efficient would be to have all the required tables etc. in a template and, if the data changes, simply re-populate the relevant ranges with the required data.
Attached Files
File Type: xlsm TinfanideStarters.xlsm (82.9 KB, 17 views)
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Strange VBA ListTemplate ListLevel Problem Strange problem with new font bkersh PowerPoint 1 07-06-2011 09:03 AM
Strange Word Document Problem. ookami Word 5 05-10-2011 02:26 AM
Strange VBA ListTemplate ListLevel Problem Strange Outlook startup problem Cec Britton Outlook 1 09-12-2010 10:14 AM
Strange VBA ListTemplate ListLevel Problem Strange wornways Forum Support 2 08-11-2010 06:34 PM
Strange VBA ListTemplate ListLevel Problem Strange problem with Word Revol Word 3 10-21-2009 10:32 AM

Other Forums: Access Forums

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


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