Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #46  
Old 05-23-2023, 02:18 PM
Marrick13 Marrick13 is offline Loop through listboxes in Application.OrganizerCopy Windows XP Loop through listboxes in Application.OrganizerCopy Office 2010 32bit
Competent Performer
Loop through listboxes in Application.OrganizerCopy
 
Join Date: Jun 2006
Posts: 102
Marrick13 will become famous soon enough
Default


Cricket,

I am the guy who wrote (most of) Style Copier (needed some help from one of the gurus) and it's still good (and updated for 64-bit PCs). So, have at it!
Reply With Quote
  #47  
Old 05-26-2023, 03:11 AM
macropod's Avatar
macropod macropod is offline Loop through listboxes in Application.OrganizerCopy Windows 10 Loop through listboxes in Application.OrganizerCopy Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
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

Nothing has changed in Office to prevent the code working in any current version. Did you at least try it?
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #48  
Old 04-06-2024, 02:02 AM
hank1234 hank1234 is offline Loop through listboxes in Application.OrganizerCopy Windows 11 Loop through listboxes in Application.OrganizerCopy Office 2016
Novice
 
Join Date: Sep 2020
Posts: 9
hank1234 is on a distinguished road
Question

I'm currently using a DOTM file that Charles shared on Word 365, but I'm facing some performance issues. It's incredibly slow, taking over a minute just to copy a single style. Additionally, I receive an error message stating, "Microsoft Office has identified a potential security concern," and it mentions that the execution of a macro has been blocked. Interestingly, the notification points to a tmp-file in the AppData / User folder, which doesn't seem to relate to the actual files in use:
C:\Users\[username] \AppData\Local\Microsoft\Windows\INetCache\Content .Word\~WRC1782.tmp.
In Task Manager, I notice that there are eight instances of Word open (even though Word doesn't appear to be active).

I've given the DOTM a go with the test files/template mentioned in post 7 of this thread. Also, I had to comment out the lines with wdTmp because they were throwing errors for me.

I'm really hoping to get some insight or assistance from any of the developers here. Has anyone faced similar issues or knows how to work around this? I'm attaching the DOTM file I'm working with to this post.
Attached Files
File Type: dotm Style Copier Application.dotm (101.2 KB, 0 views)
Reply With Quote
  #49  
Old 04-16-2024, 12:40 PM
Charles Kenyon Charles Kenyon is offline Loop through listboxes in Application.OrganizerCopy Windows 11 Loop through listboxes in Application.OrganizerCopy Office 2021
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,124
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

Sorry for the late response.
The code in Paul's .doc file still runs fine if you can get it past your Trust Center settings. The same code is in the .dotm file I posted which can be place in your StartUp folder. Both run fine in the Word in Micrsoft 365 version 2404.
Reply With Quote
  #50  
Old 04-16-2024, 12:45 PM
Charles Kenyon Charles Kenyon is offline Loop through listboxes in Application.OrganizerCopy Windows 11 Loop through listboxes in Application.OrganizerCopy Office 2021
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,124
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 hank1234 View Post
I'm currently using a DOTM file that Charles shared on Word 365, but I'm facing some performance issues. It's incredibly slow, taking over a minute just to copy a single style. Additionally, I receive an error message stating, "Microsoft Office has identified a potential security concern," and it mentions that the execution of a macro has been blocked. Interestingly, the notification points to a tmp-file in the AppData / User folder, which doesn't seem to relate to the actual files in use:
C:\Users\[username] \AppData\Local\Microsoft\Windows\INetCache\Content .Word\~WRC1782.tmp.
In Task Manager, I notice that there are eight instances of Word open (even though Word doesn't appear to be active).

I've given the DOTM a go with the test files/template mentioned in post 7 of this thread. Also, I had to comment out the lines with wdTmp because they were throwing errors for me.

I'm really hoping to get some insight or assistance from any of the developers here. Has anyone faced similar issues or knows how to work around this? I'm attaching the DOTM file I'm working with to this post.

I just reposted the .dotm but there are no changes to the code there.


When running on my machine using Microsoft 365 ver. 2404 I am not seeing any multiple instances. I have not tested with the test document.
Reply With Quote
  #51  
Old 04-16-2024, 01:21 PM
Charles Kenyon Charles Kenyon is offline Loop through listboxes in Application.OrganizerCopy Windows 11 Loop through listboxes in Application.OrganizerCopy Office 2021
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,124
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

Note the limitations Paul noted previously with Built-In Styles.

You may want to use [Quick] Style Sets instead.
There may be limits to how many styles you can have in such a set. They do have to be designated for display in the Gallery to be included in a set.
[Quick] Style Sets and Word Themes in Microsoft Word


See also: A Global StyleSheet in Microsoft Word?
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to use for loop in formula in VBA? tinfanide Excel Programming 1 12-06-2011 08:33 AM
music loop in powerpoint presentation genoMU69 PowerPoint 1 06-15-2011 08:00 AM
While loop not working right Cbrehm Excel Programming 0 05-11-2011 11:05 AM
Loop through listboxes in Application.OrganizerCopy Continuous Loop cksm4 Word 6 01-06-2011 09:03 PM
Outlook 2003 restart in a loop Stegel Outlook 0 06-29-2007 12:34 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:55 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