toddbailey
03-02-2012, 04:54 PM
Hi All,
I have a application that can run from a few seconds to over 1/2 an hour depending on the user supplied part numbers entered. The code is well written and optimized. I've recently ported parts of the user interface to a user form and are now running into excel and user form responce issues while the code is executing. The code base has 2 distinct functions, gather and calculate cost data and store in access tables, then populate a series of excel worksheets.
Are there any settings I can make to the form properties or to Excel that will improve responce, ie: form doesn't repaint when a application that covers the form is closed, or moving form doesn't occur instantanously.
The code base is a few thousand lines long and has to loop through a lot of data from an access database.
I can't post the code cause there is just too much plus an NDA
I sprinkled a lot of doevents that seem to have helped, but I expect the form to be movable and continously updated during code execution.
It's possible I need to port the data gather stage to C# but also consider using a different database engine.
Any suggestions or tips on how to make a user form more detached from running vb/a code.
thanks
I have a application that can run from a few seconds to over 1/2 an hour depending on the user supplied part numbers entered. The code is well written and optimized. I've recently ported parts of the user interface to a user form and are now running into excel and user form responce issues while the code is executing. The code base has 2 distinct functions, gather and calculate cost data and store in access tables, then populate a series of excel worksheets.
Are there any settings I can make to the form properties or to Excel that will improve responce, ie: form doesn't repaint when a application that covers the form is closed, or moving form doesn't occur instantanously.
The code base is a few thousand lines long and has to loop through a lot of data from an access database.
I can't post the code cause there is just too much plus an NDA
I sprinkled a lot of doevents that seem to have helped, but I expect the form to be movable and continously updated during code execution.
It's possible I need to port the data gather stage to C# but also consider using a different database engine.
Any suggestions or tips on how to make a user form more detached from running vb/a code.
thanks