PDA

View Full Version : Runtime error 5891



jon_w
07-22-2011, 06:21 AM
Hi All,

When I run my VBA code which opens a word doc, I get runtime error 5891 'could not open macro storage'

I've had a bit of a look on the net and seen it could be the normal.dot file being corrupt. I deleted it AND renamed it on two separate occasions but it didn't fix the problem.

Its strange seeing as I've tested the script time and time again as I've added to it, and only just now has it created this error.

Anyone know whats causing the error and how to fix it?

Thanks
j

Frosty
07-24-2011, 12:25 PM
It could also be that Word isn't *allowed* to open the macro because of a security setting.

Or, it could be a bad error message (i.e., pointing you in the wrong direction to solve it).

If you can post specific code, the answers will be more specific.