I spent many hours today working on a Word template that has had significant editing over the last months. From time to time, I export all of the modules, user forms, AutoText and toolbar and import these components into a new container.. The file size usually decreases by 25% when I do that. I compile the template after importing.
After going through this process today, an error displayed the first time I launched the template. The message said, "Automation error. Unspecified error." It occurred once, and has not appeared again, after testing 25 or 30 times. I modified the template slightly, so it was compiled again and saved. When I uploaded the template to the network, the same thing occured: once, and only once, the Automation Error message appeared, and not since.
Is there any sense to be made from the "unspecified error" message? Debug|Compile is problem-free, and the code runs perfectly. Even when the error appears on the initial run, there is no probelm with code execution. It's a rather large template: 14 user forms, 5 code modules, 1 custom toolbar and 5 AutoText entries. The only unusual item in the template is the Date Picker on 4 of the user forms.