Minty
AWF VIP
- Local time
- Today, 05:28
- Joined
- Jul 26, 2013
- Messages
- 10,702
Powerpoint automation is equally flakey.
Long routines that run fine 95% of the time will error out, normally with an "Object not defined" or when trying to activate chart data worksheets "Object not available" or some other similarly vague message.
Even more frustratingly, if you click continue, it carries on running completes the action it said it couldn't and works until the next random error. Go figure.
It also slows down significantly if you have had things open for a while. One routine that updates 8 different sets of slides, if you reboot before setting it off takes approx 4 minutes per set. The last time I ran it this week (forgetting to reboot), it took 1 hour 20 minutes.
Long routines that run fine 95% of the time will error out, normally with an "Object not defined" or when trying to activate chart data worksheets "Object not available" or some other similarly vague message.
Even more frustratingly, if you click continue, it carries on running completes the action it said it couldn't and works until the next random error. Go figure.
It also slows down significantly if you have had things open for a while. One routine that updates 8 different sets of slides, if you reboot before setting it off takes approx 4 minutes per set. The last time I ran it this week (forgetting to reboot), it took 1 hour 20 minutes.