Hi,
I've a workbook that opens and saves perfectly and consistently on my own machine, but that sometimes gives a 'Compile Error in hidden module: Module 1' error when opened (perhaps after just one re-save) on some other PCs.
How do I go about fault-finding?
I've found many references to this sort of error on the web from several years ago, and had lots of problems running my file on other machines after the Dec '14 MS Security Update problem, but I think those issues are behind me.
The machines generally differ in whether they run Office 10/13, Windows 7/8.1, and 32-bit/64bit. I obviously want to write a robust program that correctly saves/re-opens irrespective of the exact PC on which it's used.
Should I try to isolate exactly what combinations of systems create the error, or do I run the debugger as soon as the fault is encountered, or...
Or would it be helpful if I checked the VBA References on each of the machines?
I really don't understand what sort of problem I've got, and hence where to (systematically) start looking.
Thanks in anticipation for your advice. :-)
MathUKTeacher (amateur programmer)
Bookmarks