| T O P I C R E V I E W |
| ChemistryGuy |
Posted - 12/01/2022 : 5:51:03 PM
Origin Ver. and Service Release: 8
I have developed a VBA program that uses COM automation to import data to Origin, and generate a plot. The program works with my version of Origin, which is 2023. However, another user tried to use this program with Origin 8 and experienced an error.
Specifically, the following error message was displayed:
Run-time error '-2147417851 (80010105)'
Automation error
The server threw an exception.
The line of code that triggered this error was:
LayerCount = wbk.Layers.Count
Based on this, I suspect the issue is that COM automation does not work with Origin 8, and the user needs to upgrade to a more recent version of Origin. However, I just wanted to double check this: Please would you advise me if COM is unavailable for Origin 8, or if you think there may be a different cause for this error? |
| 1 L A T E S T R E P L I E S (Newest First) |
| minimax |
Posted - 12/08/2022 : 02:20:36 AM
Hi,
Based on our limited knowledge of COM, it is version dependent. (it might be not, but we do not know how to make it independent)
so you will have to build the program for each Origin version. (Origin 8 supports COM) |
|
|
