node

Hi Guys, I’m hoping someone can help me with this. I’m trying to find a xml node, I can find the node, however, I need to look for the node from what’s entered in a userform textbox. Here is the code I’m using: Private sub commandbutton1_click() Dim xmlObj As Object Dim singlenode As Object...

Hello! I would like to show a message box with the text of each node clicked on my smartart. I would like to return the node text and not the main object text. I tried using Application.Caller and it didn't work Help would be much appreciated! :)

Really, I just can't believe that I constantly get the "Can't assign to array" error message... :( I can read an XML file easily and assign the node values to a collection but the same is not true for an array. I don't know why, I guess I need to read more about Collection vs Array differences...

Hello, We've a table generated from a legacy application that generates a list of parent-child relationship like a tree or an employee hierarchy listing. <tbody> Label ID ParentID A 1 B 2 1 C 3 1 D 4 2 E 5 2 F 6 3 G 7 4 </tbody> We want to find all the paths to every leaf a...

Greetings! I am plotting a radar chart with 6 nodes (based on each of the parameter values). The Excel plot rightly plots the dimensions on 6 different nodes, but also creates a dummy node axis, without any parameter. Is there any advise on how to remove this 7th node (with the 6 parameters to...

I have a spreadsheet that I'm using to import data from a webpage. I've been able to pull in everything from the page but I'm looking for the information in a specific node. I'm having trouble pulling it in. Here's the info Site: https://leagueofcomicgeeks.com/profile/mauricem72/pull-list I'm...

Hi there, I am using a web service for the first time and need some help extracting the values returned in the XML after the POST. I have a loop which does this successfully once I specify the parent node. But within the XML returned there is a point in which another parent node with child...

Hello everybody, I have to model branched water supply network showed in picture attached here https://goo.gl/jJFhMx. Node numbers are written in brackets, while pipe numbers are written in red and rectangled. Water demand is defined in nodes and marked with an arrow. So, input data are pipe...

Hi all, I haven't been able to find much on this through google. I have a pivot table that is filtered at a header level (i.e. not row or column) and this filter has multiple nodes to it. What I am trying to do is filter on a node 3 levels down and unfilter on a couple items within that node...

This is some recorded code from SAP to select a node within a VA03/CU51 transaction. If Not IsObject(application) Then Set SapGuiAuto = GetObject("SAPGUI") Set application = SapGuiAuto.GetScriptingEngine End If If Not IsObject(connection) Then Set connection = application.Children(0)...

Hi everyone, I am facing a problem in Excel. First, I need to use VBA because it is impossible to add a row in excel without using VBA (of what I know...). The problem I am facing is that I have a data structure with thousands of lines in a tree type within the same column: BASIC COLUMN C1...

Please help me in writing the formula. Because of match first occurence it is getting repeated. I have "From", "To" NODE IDs of road segments which are not in order and needs to be reordered. I found the two unique values which are first node and last node of the corridor and started with one...