Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 10-09-2023, 12:50 AM
ArviLaanemets ArviLaanemets is offline Do VBA Projects remaining visible in VBAProject window after they are closed matter somehow? Windows 8 Do VBA Projects remaining visible in VBAProject window after they are closed matter somehow? Office 2016
Expert
Do VBA Projects remaining visible in VBAProject window after they are closed matter somehow?
 
Join Date: May 2017
Posts: 949
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default Do VBA Projects remaining visible in VBAProject window after they are closed matter somehow?

This is linked to my previous post.

I open in my Excel app sequentally other workbooks (currently in same instance), do something, and then close them. After the workbook is closed, the VBAProject of closed Excel file remains displayed in VBAProject window of my App.

Does this mean, that those closed files are using up some of RAM? Because the number of files to be processed this way is currently about 1000, and my App crashed after ~300 of those secondary files were processed.



(As afterthought, when this is the cause, then I probably have to open all secondary files in separate instance, and to clear this secondary instance every time a secondary workbook is closed there)
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Word 2013, when switching to next window, often opens it as a tiny window amz Word 1 04-20-2021 12:25 AM
How to call a function in VBAProject(PERSONAL.XLSB) coffent Excel Programming 0 05-17-2020 11:31 AM
How to show days remaining oliboi Excel 6 01-24-2019 10:29 AM
Word window empty when opened minimized while Visible is False qtutorm Word VBA 2 10-08-2018 09:10 AM
Time Remaining Progress Bar teza2k06 Excel 1 05-13-2014 05:41 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:45 AM.


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