The problem: On my machine and two others, there is a "compile error: automation error" when attempting to run code in an Excel 2000 workbook. This doesn't occur on a dozen other machines.
The situation:
I am part of a three-person development team on an Excel workbook that launches a form on startup, takes user input on a series of forms, then crunches a lot of numbers. Next, it copies certain worksheets (the results) into a new workbook. Then, it takes those resulting worksheets and creates a PowerPoint presentation based on them.
For a while, I was working on one part of the project (the PowerPoint presentation generation) and someone else was working on the front end (the forms). When we tried to put our versions together using my computer, at some point my computer crashed, and after that the workbook has not run on my machine. I tested it on the machine that someone next to me uses, and it caused the same error: "Compile error: Automation Error." It just won't compile.
We reconciled our two versions on the other developer's machine, and it worked fine. We tested the final version on over a dozen other machines, Windows 98 and Windows 2000 alike, and they all worked. These are people who usually don't run code.
The spooky part about it is that not only did the problem persist when I reinstalled Office 2000 several times, but it persisted when I got a new computer! It was a hand-me-down computer from someone else, who happened to have run the code on this workbook just smoothly before I got his machine.
And the other computer next to me still won't compile the code on this workbook. But other workbooks with code in them do work just fine on my machine and the machine next to me. My original machine ran Windows 98, my current one runs Windows 2000, and the person next to my runs Windows 2000. As far as I know, all people involved have Office 2000.
Any ideas?
Christopher
The situation:
I am part of a three-person development team on an Excel workbook that launches a form on startup, takes user input on a series of forms, then crunches a lot of numbers. Next, it copies certain worksheets (the results) into a new workbook. Then, it takes those resulting worksheets and creates a PowerPoint presentation based on them.
For a while, I was working on one part of the project (the PowerPoint presentation generation) and someone else was working on the front end (the forms). When we tried to put our versions together using my computer, at some point my computer crashed, and after that the workbook has not run on my machine. I tested it on the machine that someone next to me uses, and it caused the same error: "Compile error: Automation Error." It just won't compile.
We reconciled our two versions on the other developer's machine, and it worked fine. We tested the final version on over a dozen other machines, Windows 98 and Windows 2000 alike, and they all worked. These are people who usually don't run code.
The spooky part about it is that not only did the problem persist when I reinstalled Office 2000 several times, but it persisted when I got a new computer! It was a hand-me-down computer from someone else, who happened to have run the code on this workbook just smoothly before I got his machine.
And the other computer next to me still won't compile the code on this workbook. But other workbooks with code in them do work just fine on my machine and the machine next to me. My original machine ran Windows 98, my current one runs Windows 2000, and the person next to my runs Windows 2000. As far as I know, all people involved have Office 2000.
Any ideas?
Christopher
