Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
make my vba/excel program faster
Hi
see your other post -- Regards Frank Kabel Frankfurt, Germany Neil wrote: I have a vba program. It was really slow b/c it accessed the spreadsheet cell by cell. I made the program a lot faster by using arrays to do mass input and output with the spreadsheet. I would like to make the program faster. What else can I do? The time consuming part seems to be 1)the actual writing to the spreadsheet by vba and 2)the opening of the software. to open it, you double click the .xls file. It takes about 10 seconds to load up. thanks. Neil |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I make reports faster in excel using ADO | Excel Discussion (Misc queries) | |||
Make Excel Work faster | New Users to Excel | |||
Make excel run large spreadsheets faster | Excel Discussion (Misc queries) | |||
make my vba/excel program faster | Excel Programming | |||
make my VBA program faster | Excel Programming |