vba application acting irregular

**kmakjop** · 10-12-2012, 03:33 PM

Ok I wrote my first application from ground up purely from help from you guys here and reading online material. However now that the application is basically near completion, I observed that in some instances when I try to execute the application I get a run time error in areas that i know for a fact is working. When I restart the computer the application will again start to operate in a fully functional manner.

Can anyone shed some light here? Why do I have to restart my computer for the application to regularize itself?

**HaHoBe** · 10-13-2012, 12:49 PM

Hi, kmakjop,

Can anyone shed some light here?

Sadly not me with the little light I can bring in without looking at your code. Avoid Copy&Paste, set objects for workbooks and worksheets, release these at the end (although MS tells that they only have scope for the run-time of the procedure), avoid using too many globals and statics, maybe use smaller procedures for tasks which are used multiple times where information is passed as parameter.

HTH,
Holger

vba application acting irregular

LinkBack

Thread Tools

Rate This Thread

Display

vba application acting irregular

Re: vba application acting irregular

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions