ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   need for speed! (https://www.excelbanter.com/excel-programming/298876-need-speed.html)

Neil[_19_]

need for speed!
 
So I have been working on this big excel project. It was slow b/c it did cell by cell reference. I really speeded it up by changing all that to use arrays

My only issues now is that when you double click on the excel icon for the project to open it, it takes like 30 seconds to load...dude!!!!!Can I speed this up and how. Is there something in VBA I can do to make it not load up all that stuff it is loading up that may not be needed

Thank you very muc

Neil

Frank Kabel

need for speed!
 
Hi
how large is your file and are you running some macros on start-up?

--
Regards
Frank Kabel
Frankfurt, Germany


Neil wrote:
So I have been working on this big excel project. It was slow b/c it
did cell by cell reference. I really speeded it up by changing all
that to use arrays.

My only issues now is that when you double click on the excel icon
for the project to open it, it takes like 30 seconds to
load...dude!!!!!Can I speed this up and how. Is there something in
VBA I can do to make it not load up all that stuff it is loading up
that may not be needed?

Thank you very much

Neil



All times are GMT +1. The time now is 05:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com