Member Avatar

Hi Guys!! I am creating an addin in Excel using VB.Net. I want to access the current worksheet using a ribbon designer. I have tried all sorts but to no avail. Also all the resources that I have checked are providing solutions by adding or opening new workbook. What I want is to create a reference to the active worksheet. For example by adding what we get is Imports Microsoft.Office.Tools.Ribbon Imports Microsoft.Office.Interop Imports System.Windows.Forms Dim currApp As Excel.Application Dim curSheet As Excel.Worksheet Dim curSheets As Excel.Sheets Dim curBook As Excel.Workbook Dim curBooks As Excel.Workbooks Private Sub Ribbon1_Load(ByVal sender As Object, …

Member Avatar
+0 forum 2 7
Member Avatar

Office Addin Hello all I've searched Google for hours, with no success. I have developed an Office 2010 addin application. The application adds another form to Outlook.(Form Region) The application (let's call it A) works great! I can send emails from my Outlook with this form (filled or not filled with data from the user). So far so good. Now, I have another winapp. It has textBoxes. (Let's call this app B). What I need: I need to take the data that the user enters in B's textBoxes, and put in inside A (inside the Region form). So i tried …

+0 forum 0 1
Member Avatar

**Hello all** I've searched Google for hours, with no success. I have developed an Office 2010 addin application. The application adds another form to Outlook.(Form Region) The application (let's call it A) works great! I can send emails from my Outlook with this form (filled or not filled with data from the user). So far so good. Now, I have another winapp. It has textBoxes. (Let's call this app B). What I need: I need to take the data that the user enters in B's textBoxes, and put in inside A (inside the Region form). So i tried to add …

+0 forum 0 1
Member Avatar

Well, when almost finishing this tutorial: [INDENT][/INDENT][url]http://msdn.microsoft.com/en-us/library/ff677562.aspx[/url] I found a problem on connecting the Add-in to the database, and so the lobInstance canĀ“t be opened: [url]http://i.stack.imgur.com/AFzie.png[/url] This is the error code. (in fact the error message was being popped out when the Excel 2010 client starts, but I commented the exception in order to see the full details of the problem). [CODE]Microsoft.BusinessData.Runtime.CannotConnectException was unhandled by user code Message=Cannot connect to the LobSystem (External System). Source=Microsoft.Office.BusinessData HasExplicitMessage=true IsRetriable=false StackTrace: Server stack trace: at Microsoft.Office.BusinessData.SystemSpecific.Db.DbConnectionManager.Execute(Object[] args) at Microsoft.Office.BusinessData.Infrastructure.WindowsAuthenticator.ExecuteAfterConstrainedDelegation(Object[] args) at Microsoft.Office.BusinessData.SystemSpecific.Db.DbConnectionManager.GetConnection() at Microsoft.Office.BusinessData.SystemSpecific.Db.DbSystemUtility.ExecuteStatic(IMethodInstance methodInstance, ILobSystemInstance lobSystemInstance, Object[] args, IExecutionContext context) at Microsoft.Office.BusinessData.Runtime.DataClassRuntime.ExecuteInternalWithAuthNFailureRetry(ISystemUtility …

+0 forum 0 1
Member Avatar

Hi All, I am developing an Excel Add-in using Visual Studio Tools for Office using C#. However, the problem is that i want to use the SOLVER add-in that is available in Excel in my code. I cannot find any way or documentation anywhere for doing the same. However i tried some code [CODE] //namespaces used using VBIDE = Microsoft.Vbe.Interop; using Excel = Microsoft.Office.Interop.Excel; using Office = Microsoft.Office.Core; //path where solver add-in is by-default installed string solverPath = @"c:\program files\microsoft office\OFFICE14\library\SOLVER\SOLVER.XLAM"; //running Solver add-in workbook.Application.Run("SOLVER.Auto_open", Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, …

+0 forum 0 1
Member Avatar

Dear all, I'm a newbie Outlook Add-in and I have developed a small Outlook Add-in, but now I have an issue with the Add-in. Sample source code is bellow: [CODE] using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Xml.Linq; using Outlook = Microsoft.Office.Interop.Outlook; using Office = Microsoft.Office.Core; using System.Windows.Forms; using System.Runtime.InteropServices; using System.IO; namespace OutlookAddIn1 { public partial class ThisAddIn { private void ThisAddIn_Startup(object sender, System.EventArgs e) { this.Application.ItemSend += new Microsoft.Office.Interop.Outlook.ApplicationEvents_11_ItemSendEventHandler(Application_ItemSend); } void Application_ItemSend(object Item, ref bool Cancel) { Outlook._MailItem mailItem = (Outlook._MailItem)Item; try { string strTempFileName = string.Empty; string strTempPath = Path.GetTempPath(); DateTime dtCurrent = DateTime.Now; strTempFileName …

+0 forum 0 1
Member Avatar

I have been working on several plugins for office. One for Word, one for excel. They are working fine on the developer system however when I try to install the Word plugin on any other machine it doesn't appear to register with Word at all. It isn't listed in the com add-ins in word. It is listed in the registry under add-ins (HK_CURRENT_USER area), it does appear in add/remove software and I can not find any indication of why it wouldn't be loading. The excel plugin (which uses some of the same code) does install and work without issues. Any …

Member Avatar
+0 forum 1 2

The End.