i'm trying write visual basic code in visual studio 2012 able open , make changes existing microsoft excel workbook (office 2010). code i've come with:
dim billingcalender string = *path excel workbook* dim xlsapp excel.application = new excel.application dim xlsworkbooks excel.workbooks = xlsapp.workbooks dim xlswb excel.workbook = xlsworkbooks.open(billingcalender) however, whenever try run this, new excel workbook opened , following error given:
an add-in not found or not loaded not create instance of startup object recreateempty.recreateempty in assembly recreateempty, version=1.0.0.0, culture=neutral, publickeytoken=null. ************** exception text ************** microsoft.visualstudio.tools.applications.runtime.cannotcreatestartupobjectexception: not create instance of startup object recreateempty.recreateempty in assembly recreateempty, version=1.0.0.0, culture=neutral, publickeytoken=null. ---> system.reflection.targetinvocationexception: exception has been thrown target of invocation. ---> system.runtime.interopservices.comexception: retrieving com class factory component clsid {00024500-0000-0000-c000-000000000046} failed due following error: 80080005 server execution failed (exception hresult: 0x80080005 (co_e_server_exec_failure)). @ system.runtime.remoting.remotingservices.allocateuninitializedobject(runtimetype objecttype) @ system.runtime.remoting.activation.activationservices.createinstance(runtimetype servertype) @ system.runtime.remoting.activation.activationservices.iscurrentcontextok(runtimetype servertype, object[] props, boolean bnewobj) @ system.runtimetypehandle.createinstance(runtimetype type, boolean publiconly, boolean nocheck, boolean& canbecached, runtimemethodhandleinternal& ctor, boolean& bneedsecuritycheck) @ system.runtimetype.createinstanceslow(boolean publiconly, boolean skipcheckthis, boolean fillcache, stackcrawlmark& stackmark) @ system.runtimetype.createinstancedefaultctor(boolean publiconly, boolean skipcheckthis, boolean fillcache, stackcrawlmark& stackmark) @ system.activator.createinstance(type type, boolean nonpublic) @ system.activator.createinstance(type type) @ recreateempty.recreateempty..ctor(applicationfactory factory, iserviceprovider serviceprovider) in c:\users\c33426s\documents\visual studio 2012\projects\recreateempty\recreateempty\thisaddin.vb:line 6 --- end of inner exception stack trace --- @ system.runtimemethodhandle.invokemethod(object target, object[] arguments, signature sig, boolean constructor) @ system.reflection.runtimeconstructorinfo.invoke(bindingflags invokeattr, binder binder, object[] parameters, cultureinfo culture) @ microsoft.visualstudio.tools.office.runtime.domaincreator.executecustomization.createentrypoint(string entrypointtypename) --- end of inner exception stack trace --- @ microsoft.visualstudio.tools.office.runtime.domaincreator.executecustomization.createentrypoint(string entrypointtypename) @ microsoft.visualstudio.tools.office.runtime.domaincreator.executecustomization.microsoft.visualstudio.tools.office.runtime.interop.iexecutecustomization2.loadentrypoints(intptr serviceprovider) ************** loaded assemblies ************** mscorlib assembly version: 4.0.0.0 win32 version: 4.0.30319.34209 built by: fx452rtmgdr codebase: file:///c:/windows/microsoft.net/framework/v4.0.30319/mscorlib.dll ---------------------------------------- microsoft.visualstudio.tools.office.runtime assembly version: 10.0.0.0 win32 version: 10.0.60724.0 codebase: file:///c:/windows/microsoft.net/assembly/gac_msil/microsoft.visualstudio.tools.office.runtime/v4.0_10.0.0.0__b03f5f7f11d50a3a/microsoft.visualstudio.tools.office.runtime.dll ---------------------------------------- system.core assembly version: 4.0.0.0 win32 version: 4.0.30319.34209 built by: fx452rtmgdr codebase: file:///c:/windows/microsoft.net/assembly/gac_msil/system.core/v4.0_4.0.0.0__b77a5c561934e089/system.core.dll ---------------------------------------- system assembly version: 4.0.0.0 win32 version: 4.0.30319.34294 built by: fx452rtmgdr codebase: file:///c:/windows/microsoft.net/assembly/gac_msil/system/v4.0_4.0.0.0__b77a5c561934e089/system.dll ---------------------------------------- system.configuration assembly version: 4.0.0.0 win32 version: 4.0.30319.34209 built by: fx452rtmgdr codebase: file:///c:/windows/microsoft.net/assembly/gac_msil/system.configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/system.configuration.dll ---------------------------------------- system.xml assembly version: 4.0.0.0 win32 version: 4.0.30319.34283 built by: fx452rtmgdr codebase: file:///c:/windows/microsoft.net/assembly/gac_msil/system.xml/v4.0_4.0.0.0__b77a5c561934e089/system.xml.dll ---------------------------------------- system.security assembly version: 4.0.0.0 win32 version: 4.0.30319.34291 built by: fx452rtmgdr codebase: file:///c:/windows/microsoft.net/assembly/gac_msil/system.security/v4.0_4.0.0.0__b03f5f7f11d50a3a/system.security.dll ---------------------------------------- microsoft.visualstudio.tools.applications.hosting assembly version: 10.0.0.0 win32 version: 10.0.60724.0 codebase: file:///c:/windows/microsoft.net/assembly/gac_msil/microsoft.visualstudio.tools.applications.hosting/v4.0_10.0.0.0__b03f5f7f11d50a3a/microsoft.visualstudio.tools.applications.hosting.dll ---------------------------------------- microsoft.visualstudio.tools.applications.runtime assembly version: 10.0.0.0 win32 version: 10.0.60724.0 codebase: file:///c:/windows/microsoft.net/assembly/gac_msil/microsoft.visualstudio.tools.applications.runtime/v4.0_10.0.0.0__b03f5f7f11d50a3a/microsoft.visualstudio.tools.applications.runtime.dll ---------------------------------------- system.deployment assembly version: 4.0.0.0 win32 version: 4.0.30319.34280 built by: fx452rtmgdr codebase: file:///c:/windows/microsoft.net/assembly/gac_msil/system.deployment/v4.0_4.0.0.0__b03f5f7f11d50a3a/system.deployment.dll ---------------------------------------- microsoft.visualstudio.tools.applications.serverdocument assembly version: 10.0.0.0 win32 version: 10.0.60724.0 codebase: file:///c:/windows/microsoft.net/assembly/gac_msil/microsoft.visualstudio.tools.applications.serverdocument/v4.0_10.0.0.0__b03f5f7f11d50a3a/microsoft.visualstudio.tools.applications.serverdocument.dll ---------------------------------------- system.windows.forms assembly version: 4.0.0.0 win32 version: 4.0.30319.34251 built by: fx452rtmgdr codebase: file:///c:/windows/microsoft.net/assembly/gac_msil/system.windows.forms/v4.0_4.0.0.0__b77a5c561934e089/system.windows.forms.dll ---------------------------------------- system.drawing assembly version: 4.0.0.0 win32 version: 4.0.30319.34285 built by: fx452rtmgdr codebase: file:///c:/windows/microsoft.net/assembly/gac_msil/system.drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/system.drawing.dll ---------------------------------------- system.xml.linq assembly version: 4.0.0.0 win32 version: 4.0.30319.34209 built by: fx452rtmgdr codebase: file:///c:/windows/microsoft.net/assembly/gac_msil/system.xml.linq/v4.0_4.0.0.0__b77a5c561934e089/system.xml.linq.dll ---------------------------------------- microsoft.office.tools assembly version: 10.0.0.0 win32 version: 10.0.60724.0 codebase: file:///c:/windows/microsoft.net/assembly/gac_msil/microsoft.office.tools/v4.0_10.0.0.0__b03f5f7f11d50a3a/microsoft.office.tools.dll ---------------------------------------- microsoft.office.tools.excel.implementation assembly version: 10.0.0.0 win32 version: 10.0.60724.0 codebase: file:///c:/windows/microsoft.net/assembly/gac_msil/microsoft.office.tools.excel.implementation/v4.0_10.0.0.0__b03f5f7f11d50a3a/microsoft.office.tools.excel.implementation.dll ---------------------------------------- microsoft.office.tools.common.implementation assembly version: 10.0.0.0 win32 version: 10.0.60724.0 codebase: file:///c:/windows/microsoft.net/assembly/gac_msil/microsoft.office.tools.common.implementation/v4.0_10.0.0.0__b03f5f7f11d50a3a/microsoft.office.tools.common.implementation.dll ---------------------------------------- microsoft.office.tools.common assembly version: 10.0.0.0 win32 version: 10.0.60724.0 codebase: file:///c:/windows/microsoft.net/assembly/gac_msil/microsoft.office.tools.common/v4.0_10.0.0.0__b03f5f7f11d50a3a/microsoft.office.tools.common.dll ---------------------------------------- recreateempty assembly version: 1.0.0.0 win32 version: 1.0.0.0 codebase: file:///c:/users/c33426s/documents/visual%20studio%202012/projects/recreateempty/recreateempty/bin/debug/recreateempty.dll ---------------------------------------- microsoft.office.tools.common.v4.0.utilities assembly version: 10.0.0.0 win32 version: 10.0.30319.1 codebase: file:///c:/users/c33426s/documents/visual%20studio%202012/projects/recreateempty/recreateempty/bin/debug/microsoft.office.tools.common.v4.0.utilities.dll ---------------------------------------- microsoft.office.tools.excel assembly version: 10.0.0.0 win32 version: 10.0.60724.0 codebase: file:///c:/windows/microsoft.net/assembly/gac_msil/microsoft.office.tools.excel/v4.0_10.0.0.0__b03f5f7f11d50a3a/microsoft.office.tools.excel.dll ---------------------------------------- microsoft.office.interop.excel assembly version: 14.0.0.0 win32 version: 14.0.4756.1000 codebase: file:///c:/windows/assembly/gac_msil/microsoft.office.interop.excel/14.0.0.0__71e9bce111e9429c/microsoft.office.interop.excel.dll ---------------------------------------- office assembly version: 14.0.0.0 win32 version: 14.0.4760.1000 codebase: file:///c:/windows/assembly/gac_msil/office/14.0.0.0__71e9bce111e9429c/office.dll could me understand issue , how can circumvent it?
Comments
Post a Comment