Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
why does my excel file size increase when I use visual basic editor
I am automating an excel spreadsheet by using a userform with several
textboxes and a flexgrid. It works fine, but every so often for whatever reason, the file size of the excel file increases in a very large manner. I started with a 43kb file and it was working fine. Then I noticed my machince was so and when I checked the file size it was like 33Mb, but if I go back to the original file and redo everything it is fine again for a while. Does anyone know what causes this? It has happened in both Windows XP and Windows 2000. Roger |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
why does my excel file size increase when I use visual basic editor
I've seen this happen when some userform controls go crazy.
With a copy of your workbook, try removing userforms one-by-one until you find the faulty userform (the filesize should decrease) Then from that userform, try removing controls one by one until you find which one is at fault. If you find a broken control, just remove it and add it back in again. -- Rob van Gelder - http://www.vangelder.co.nz/excel "R.H." wrote in message ... I am automating an excel spreadsheet by using a userform with several textboxes and a flexgrid. It works fine, but every so often for whatever reason, the file size of the excel file increases in a very large manner. I started with a 43kb file and it was working fine. Then I noticed my machince was so and when I checked the file size it was like 33Mb, but if I go back to the original file and redo everything it is fine again for a while. Does anyone know what causes this? It has happened in both Windows XP and Windows 2000. Roger |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Visual Basic Editor | Excel Discussion (Misc queries) | |||
Protecting Code in Visual Basic Editor (Excel 2003) | Excel Worksheet Functions | |||
Visual basic editor | Excel Discussion (Misc queries) | |||
How to disable Visual Basic Editor in Excel file | Excel Programming | |||
Visual Basic editor terminates Excel 2003 | Excel Programming |