Developer

Murray Brown

<div>
<div class="content wysiwyg-content fr-view">
Hi. I am using the following code when trying to log into Xero in my Excel Add-in and getting the error below.<br>This might be because there are two companies<br><br><pre><code class="code-1 nolinks" id="code-10-29222571-1">&nbsp; &nbsp; _xero.Companies.ForEach(Sub(x)
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Dim item = Globals.Factory.GetRibbonFactory().CreateRibbonDropDownItem()
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; item.Label = x.TenantName
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; item.Tag = x.TenantId.ToString
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; cbCompanies.Items.Add(item)
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; End Sub)</code></pre><br><a href="https://filedb.experts-exchange.com/incoming/2021/08_w34/1569698/Image1.png" rel="ugc"><img src="https://filedb.experts-exchange.com/incoming/2021/08_w34/1569698/Image1.png" class="fr-fic fr-dib"></a>
</div>
</div>


Image1.png


Hi. I am using the following code when trying to log into Xero in my Excel Add-in and getting the error below.
This might be because there are two companies
    _xero.Companies.ForEach(Sub(x)
                                    Dim item = Globals.Factory.GetRibbonFactory().CreateRibbonDropDownItem()
                                    item.Label = x.TenantName
                                    item.Tag = x.TenantId.ToString
                                    cbCompanies.Items.Add(item)
                                End Sub)

VB.net Excel AddIn System.NullReferenceException

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,

Visual Basic.NET

Xero develops cloud-based accounting software for small and medium-sized businesses. The key features of Xero include automatic bank and credit card account feeds, invoicing, accounts payable, expense claims, fixed asset depreciation, purchase orders, and standard business and management reporting. It offers a free API that enables customers and 3rd-party software vendors to integrate external applications with Xero. It also incorporates a payroll feature for users in the Australian and United States markets. All financial data is stored in the cloud on a single unified ledger, allowing users to work in the same set of books regardless of location or operating system.

Xero

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.