Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-14-2015, 09:46 AM
equalizer88 equalizer88 is offline VBA batch file to insert text at end of 50 files slow, 90% CPU usage Windows 7 32bit VBA batch file to insert text at end of 50 files slow, 90% CPU usage Office 2010 32bit
Novice
VBA batch file to insert text at end of 50 files slow, 90% CPU usage
 
Join Date: Jul 2015
Posts: 15
equalizer88 is on a distinguished road
Default


Thanks. Windows overhead with VBA still causes high CPU usage. With similar program written in "C", I'm sure overhead is much lower, but it takes longer to write, need compiler everywhere, etc.
Reply With Quote
  #2  
Old 08-16-2015, 04:56 PM
macropod's Avatar
macropod macropod is offline VBA batch file to insert text at end of 50 files slow, 90% CPU usage Windows 7 64bit VBA batch file to insert text at end of 50 files slow, 90% CPU usage Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,518
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

Quote:
Originally Posted by equalizer88 View Post
With similar program written in "C", I'm sure overhead is much lower
That doesn't necessarily follow. VBA isn't like its ancient predecessor, GW-Basic. Before execution, even VBA is semi-compiled, so all you might save is the compilation time. Besides, which would you prefer - a process that runs as quickly as possible, thereby hitting as much as 90% CPU usage, or one that keeps the CPU usage down to 25% but takes four times as long to complete (not that I'm suggesting C#-code would do this)?
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Tags
batch file insert, slow response macro, vba



Similar Threads
Thread Thread Starter Forum Replies Last Post
Remove Compatibility Mode on DOCX files (batch) w64bit Word 17 02-01-2015 06:02 AM
VBA batch file to insert text at end of 50 files slow, 90% CPU usage VBA Batch Find & Replace for all MSOffice extensions, to replace File Name and Content of the File QA_Compliance_Advisor Word VBA 11 09-11-2014 11:51 PM
VBA batch file to insert text at end of 50 files slow, 90% CPU usage how to batch update linked image files path? stanleyhuang Word 3 09-11-2014 12:51 AM
VBA batch file to insert text at end of 50 files slow, 90% CPU usage batch file romanticbiro Office 1 06-30-2014 06:04 PM
VBA batch file to insert text at end of 50 files slow, 90% CPU usage Insert-Text from File in Word Ribbon? tatihulot Word 2 10-12-2011 04:40 AM

Other Forums: Access Forums

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