ns2k

the GVars is not defined before you use it. you should change: private GlobalVars GVars; ->> private GlobalVars gvars; remove the init 'GVars = new GlobalVars();' from 'Page_Load' add 'GVars' function or property with this code: <code> if (gvars == NULL) gvars = new GlobalVars(); return (gvars); </code>

(DotNET) I have build an AddIn for MsExcel in DotNet. But Now I have problem that after a while of using it - the Excel is shutdown without any known reason. There is not Error Message/Window and no exceptions in the DotNet. Simply in the middle of the work the Excel application is shutdown. I try and did some tests and checks but I still fail to catch the problem. What reasons can cause this critical problem? Thanks

I tried to implements Microsoft.Office.Core.Range Interface, but the dot net raise errors : + ' '_Default' cannot implement '_Default' because there is no matching property on interface 'Range'.' + ' 'Item' cannot implement 'Item' because there is no matching property on interface 'Range'.' + ' 'Value' cannot implement 'Value' because there is no matching property on interface 'Range'.' see my declarations in the class below : Public Class RangeClass Implements Excel.Range ................. all kind of properties and functions that were inserted automatic by the dot net ................. Public Overridable Property _Default(Optional ByVal RowIndex As Object = Nothing, Optional ByVal ColumnIndex As Object = Nothing) As Object Implements Excel.Range._Default Get End Get Set(ByVal newValue As Object) End Set End Property Public Property Item(ByVal RowIndex As Object, Optional ByVal ColumnIndex As Object = Nothing) As Object Implements Excel.Range.Item Get End Get Set(ByVal newValue As Object) End Set End Property Public Property Value(Optional ByVal RangeValueDataType As Object = Nothing) As Object Implements Excel.Range.Value Get End Get Set(ByVal newValue As Object) End Set End Property End Class What is the reason for that?

RE Is not the reference office.dll the same as interop.office.dll? how can I reference the interop.office.dll ? the addins is dll. TX anyway ns2k

RE I remove all the references to the Microsoft Office Component and add the .Net office.dll as your screen shot. but now I have this to errors (see screen shot). can you help me please? error : + ''Public Overridable ReadOnly Default Property Item(Index As Object) As Microsoft.Office.Core.CommandBar' is declared in project 'Office.dll', which is not referenced by project 'MersAddIns.dll'. ' although I added the office.dll reference. (ExcelApp is Excel Application Object) I put screen shot of the project references also.

RE My addins contains also setup project that install the addins. The setup project also include the Microsft Office Component Dependecy - 'Interop.Microsoft.Office.Core.dll'. So I believe the setup should handle it - Q: am I wrong about it? notice that I use the setup to install the addins to other computer, but the addins doesn't work because of my problem.

Q: Using Office Component for Addins in .Net I develop an Addins Project for Excel in Visual Studio.NET that I need it to work for any machine in any Microsoft Office XP. I use the dependecy (reference) 'Interop.Microsoft.Office.Core'(Microsoft Office 10 Component) for my project. But it seem that its not work fine in others computers (differenct than the one I develop the project, where the addins work fine) the Dot NET raise errors: + "The Dependecy 'Interop.Microsoft.Office.Core' could not be found." + "The referenced component 'Microsoft.Office.Core' could not by found. A wrapper assembly is not registered for this type library." Q: How can I solve the errors above for others computers so the addins work for other computer? When I start to create the Addins project the Dot NET use the reference office.dll(under .NET references). I remove this reference because I needed the first reference(in order to use the office menus), and because those two reference can't work together(they have the same name). Q: What is this reference? Can I use it to solve my problem? How? How did you make sure that you won't have problem using the application in other computer (using this component)? How did you make sure that the addins work for other computer?

Q: Using Office Component for Addins in .Net I develop an Addins Project for Excel in Visual Studio.NET that I need it to work for any machine in any Microsoft Office XP. I use the dependecy (reference) 'Interop.Microsoft.Office.Core'(Microsoft Office 10 Component) for my project. But it seem that its not work fine in others computers (differenct than the one I develop the project, where the addins work fine) the Dot NET raise errors: + "The Dependecy 'Interop.Microsoft.Office.Core' could not be found." + "The referenced component 'Microsoft.Office.Core' could not by found. A wrapper assembly is not registered for this type library." Q: How can I solve the errors above for others computers so the addins work for other computer? When I start to create the Addins project the Dot NET use the reference office.dll(under .NET references). I remove this reference because I needed the first reference(in order to use the office menus), and because those two reference can't work together(they have the same name). Q: What is this reference? Can I use it to solve my problem? How? How did you make sure that you won't have problem using the application in other computer (using this component)? How did you make sure that the addins work for other computer?

I develop an Addins Project for Excel in Visual Studio.NET that I need it to work for any machine in any Microsoft Office XP. I use the dependecy (reference) 'Interop.Microsoft.Office.Core'(Microsoft Office 10 Component) for my project. But it seem that its not work fine in others computers (differenct than the one I develop the project, where the addins work fine) the Dot NET raise errors: + "The Dependecy 'Interop.Microsoft.Office.Core' could not be found." + "The referenced component 'Microsoft.Office.Core' could not by found. A wrapper assembly is not registered for this type library." Q: How can I solve the errors above for others computers so the addins work for other computer? When I start to create the Addins project the Dot NET use the reference office.dll(under .NET references). I remove this reference because I needed the first reference(in order to use the office menus), and because those two reference can't work together(they have the same name). Q: What is this reference? Can I use it to solve my problem? How? For those who developed project using the Office component: How did you make sure that you won't have problem using the application in other computer (using this component)? For those who developed addins project in the dot net in the past: How did you make sure that the addins work for other computer?

RE using this technic that you gave me it is not fully solve my problem because there are other MSI that need to be install (etc. MSDE) is there option to do the same in new setup project, when I can use merge module? how can I use merge module for this kind of problem?

How can I add MSDE2000 to the setup project so the MSDE2000 will also be install in the machine? If using merge module - how it can be done?

when creating a solution that also contains a setup project, there is need to add an option to install the dot net framework also in the setup project. I try to add the merge module (dotNETFXRedist_x86_enu.msm) - but the dot net raise error : - 'dotNETFXRedist_x86_enu.msm must not be used to redistribute the NET Framework, Please exclude this merge module.' How can I do it?

I have a problem to install an addin project to a computer other than the one I develop the project. The setup project work fine, but the excel doesn't run the addin - probably because it can't link the office dll in the addin project (I don't ask how to build the addins itself, but how can I build it so it will work for any computer). In other words, how can I build an addin project that will work for any computer with excel XP in it?