Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-02-2024, 09:42 AM
RRB's Avatar
RRB RRB is offline Macro runs much faster the second time it is run Windows 11 Macro runs much faster the second time it is run Office 2021
Susan Flamingo
Macro runs much faster the second time it is run
 
Join Date: May 2014
Location: The Holy City of Jerusalem
Posts: 263
RRB is on a distinguished road
Default Macro runs much faster the second time it is run

I have a really long macro that when I run it the system pauses during execution for enough time for me to turn on my motivational audio.



But if I run it again immediately afterward it does it all in a split second? What is going on here?

SF
Reply With Quote
  #2  
Old 04-02-2024, 12:23 PM
Charles Kenyon Charles Kenyon is offline Macro runs much faster the second time it is run Windows 11 Macro runs much faster the second time it is run Office 2021
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,142
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

Hi Susan,


I moved this to the Word vba forum.
Reply With Quote
  #3  
Old 04-02-2024, 03:30 PM
Guessed's Avatar
Guessed Guessed is offline Macro runs much faster the second time it is run Windows 10 Macro runs much faster the second time it is run Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,980
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

Apparently your motivational audio works on your macro too.

Have you tried playing it to your computer before running other slow macros?
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro runs much faster the second time it is run Footnote extraction macro [Why is this macro so slow? / anyway to make it faster?] Le_Blanc Word VBA 10 03-22-2021 11:38 AM
Set Macro so it runs when other open the Word Document LianaK Word VBA 1 01-25-2021 05:47 AM
Macro runs much faster the second time it is run MS WORD search macro slows way down as it runs Chopper Word VBA 8 12-21-2020 03:49 PM
Macro runs much faster the second time it is run Bold Button Runs Macro DRD992 Word VBA 1 11-22-2017 02:23 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:47 AM.


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