Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 90
Default Slow to Open, Small Workbook <2MB, HTML Paste, VBA procedures

I have a small Excel 2003 workbook 1,300kb that takes 3 to 5 minutes to open.
It was created in 2006 and has been opened daily since then.

One sheet in the book is overwritten each morning with a paste from a web
site.

That one sheet has litterly thousands of VBA procedures like the one below
(No code just the Sub - end sub). They must be being created automatically
from the html paste each morning.

Private Sub HTMLHidden999_Click()

End Sub

I suspect upon open, VBA is inspecting and compiling each sub causing the
slow to open problem.

1) Am I correct?
2) Is there a solution short of deleting each proc?
3) How do I prevent in the future?

Thanks in advance
Fred.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Stop excel from processing HTML? IE paste raw html. nick Excel Discussion (Misc queries) 2 April 21st 23 05:12 PM
cut & paste HTML markholt Excel Worksheet Functions 1 December 17th 08 06:11 PM
VBA loop slow if another workbook open George[_8_] Excel Discussion (Misc queries) 3 September 29th 08 01:30 PM
Excel Workbook slow to open Sandy M Excel Discussion (Misc queries) 2 January 9th 06 09:11 PM
Macro to open workbook and copy and paste values in to orig workbo Dena X Excel Worksheet Functions 1 December 15th 05 11:13 PM


All times are GMT +1. The time now is 08:06 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"