F
Fabz
Hi there,
I'm trying to make an Automation Add-In for Excel 2002 with VisualStudio
2008 (Professional Edition). Whatever I do, I get the following error
message when trying to add the Automation Add-In in Excel --> Tools -->
Add-Ins --> Automation --> Browse:
"The file you selected does not contain a new Automation Server, or you do
not have sufficient privileges to register the Automation Server"
1. I am working as the Administrator.
2. In VS under the project's properties I have made the following settings
--> Application "Target Framework = .NET Framework 2.0"
--> Application --> Assembly Information "Make assembly COM-visible" is
checked
--> Build --> "Register for COM Interop" is checked
3. After Building, the GUID can indeed be found in the registry as a key,
pointing to the correct .dll. By the way: The GUID was made using the Visual
Studio GUID-Tool.
4. In the code, I have set the following Labels/Attributes/whatever they're
called in .NET to my class [ComVisible(true),
ClassInterface(ClassInterfaceType.AutoDual),
Guid("F6AD0710-C59D-4f82-AE7C-071926597DE5")]
5. Somewhere in a thread I have read that Excel 2002 needs a file called
C:\Program Files\Microsoft Office\Office10\Excel.exe.config containing the
following piece of XML:
<?xml version="1.0" ?>
<configuration>
<startup>
<supportedRuntime version="v2.0.50727"/>
</startup>
</configuration>
So I put it there.
6. Somewhere I have read that if you've installed several .NET-Frameworks
the registry has to point to the correnct one:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\.NETFramework --> InstallRoot =
C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\
7. As a friend suggested, I followed this article:
http://support.microsoft.com/?scid=kb;en-us;948461&x=17&y=13.
8. For some time, when trying to add the Add-In in Excel, I recieved the
error message that mscoree.dll was missing. This I solved somehow, but
cannot remember exactly how. (I certainly did not download the file and put
it somewhere.)
And still the same error message appears.
Any ideas?
Yours,
Fabz
I'm trying to make an Automation Add-In for Excel 2002 with VisualStudio
2008 (Professional Edition). Whatever I do, I get the following error
message when trying to add the Automation Add-In in Excel --> Tools -->
Add-Ins --> Automation --> Browse:
"The file you selected does not contain a new Automation Server, or you do
not have sufficient privileges to register the Automation Server"
1. I am working as the Administrator.
2. In VS under the project's properties I have made the following settings
--> Application "Target Framework = .NET Framework 2.0"
--> Application --> Assembly Information "Make assembly COM-visible" is
checked
--> Build --> "Register for COM Interop" is checked
3. After Building, the GUID can indeed be found in the registry as a key,
pointing to the correct .dll. By the way: The GUID was made using the Visual
Studio GUID-Tool.
4. In the code, I have set the following Labels/Attributes/whatever they're
called in .NET to my class [ComVisible(true),
ClassInterface(ClassInterfaceType.AutoDual),
Guid("F6AD0710-C59D-4f82-AE7C-071926597DE5")]
5. Somewhere in a thread I have read that Excel 2002 needs a file called
C:\Program Files\Microsoft Office\Office10\Excel.exe.config containing the
following piece of XML:
<?xml version="1.0" ?>
<configuration>
<startup>
<supportedRuntime version="v2.0.50727"/>
</startup>
</configuration>
So I put it there.
6. Somewhere I have read that if you've installed several .NET-Frameworks
the registry has to point to the correnct one:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\.NETFramework --> InstallRoot =
C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\
7. As a friend suggested, I followed this article:
http://support.microsoft.com/?scid=kb;en-us;948461&x=17&y=13.
8. For some time, when trying to add the Add-In in Excel, I recieved the
error message that mscoree.dll was missing. This I solved somehow, but
cannot remember exactly how. (I certainly did not download the file and put
it somewhere.)
And still the same error message appears.
Any ideas?
Yours,
Fabz