none
Run-time error '32809' Application-defined or object-defined error RRS feed

  • Question

  • I wrote a small VBA program that worked sweet for over a year, now all of a sudden, it doesnt.
    Ive taken it to another computer and it works.

    I have other Excel files with my VBA and Macro Buttons that work on this computer that work, no error message.

    I wrote this one that now doesnt work on this computer, so its not like its new to this system.

    Has MS issued another release like it did about 6 months ago that blocks macros and buttons from working?

    This computer, Win 7, Excel 2007
    The computer is works on Win 7, Excel 2010

    But this program was written on this computer with the 2007 version.

    Ive tried stepping into the VBA and get the error message: 

    ------------------------------------------------------------------

    Run-time error '32809'Application-defined or object-defined error

    ------------------------------------------------------------------

    Clicking on the button to run the VBA does not produce the error, only stepping into the program, and
    the buttons do not work.

    The workbook/worksheet is not protected.

    Short concept of the program if it might help:
    User enters a few 'columns' of 1-2 word thoughts, over a span of up to 5 columns.
    Each column may be 2-10 rows deep.
    The program runs thru every possible combination using every word, and forms as many sentences possible 
    using all the word combinations.

    I can provide video link of its application or see it working if needed.

    Question: What does that error message indicate, and what could have changed thats not allowing me to run this on the same computer I developed in on?

    Thanks

    Wednesday, October 7, 2015 5:18 PM

Answers

  • I checked for updates as you suggested, had about 27 of them.

    Installed them, rebooted, but it didnt fix the problem.

    I had a few backups in different locations, so I tried to run them.

    Found one that worked, oddly, I dont know that there was any changes to the one

    I was working on, but at least found one that works.

    I dont know what the error code was on the other one, but at least its working.

    Thanks goodness for backups.

    Thanks for the help and ideas.

    • Marked as answer by BrainStain00 Thursday, October 8, 2015 6:19 AM
    Thursday, October 8, 2015 6:18 AM

All replies

  • Wednesday, October 7, 2015 5:34 PM
  • Well, I guess that's possible.

    How do I identify when each machine got updated, and what the update was, to compare the two?

    I didn't do it manually, so it may have on Auto Updates?

    (I hate those kind of surprises when you wake up one morning and MS has left a special treat in your chair, lol)

    Wednesday, October 7, 2015 5:44 PM
  • I would just try forcing an update or repair to Office on the machine that is failing.  The other threads haves some more drastic suggestions as well. :)
    • Proposed as answer by David_JunFeng Thursday, October 8, 2015 5:58 AM
    Wednesday, October 7, 2015 6:55 PM
  • Thanks IoTGirl,

    I will let you know how that works.

    It's like the age-old fix, reboot! right.

    Thanks for the tip.

    Wednesday, October 7, 2015 7:07 PM
  • Best of luck!
    Wednesday, October 7, 2015 7:12 PM
  • I checked for updates as you suggested, had about 27 of them.

    Installed them, rebooted, but it didnt fix the problem.

    I had a few backups in different locations, so I tried to run them.

    Found one that worked, oddly, I dont know that there was any changes to the one

    I was working on, but at least found one that works.

    I dont know what the error code was on the other one, but at least its working.

    Thanks goodness for backups.

    Thanks for the help and ideas.

    • Marked as answer by BrainStain00 Thursday, October 8, 2015 6:19 AM
    Thursday, October 8, 2015 6:18 AM
  • Interesting! If you still have both files, maybe you could run a comparison to identify the change that caused the failure.
    Thursday, October 8, 2015 4:24 PM