recursive

Hi all, This is a little Class which should allow for iterating over all running instances of excel, access and word in your computer. The GetAllApplicationsRefs Method gets you a COM reference to each and every instance of each application. As we know, the vb GetObject function attaches to...

Hello guys. I'm analyzing some unit price compositions and I need to extract labor hours, equipment hours, and materials. Some compositions have only these 3 items, but most of them have auxiliary compositions, that sometimes have other auxiliary compositions and the process becomes recursive...

I've got a big folder with weekly reports in a format "YYYY-MM.DD FILE NAME.xlsx". Each report has a worksheet named "DD report". There are 2.5 years of weekly report. I need to analyse them and I want to copy the "DD report" worksheet from each into one master file under the date name (so "DD...

Below is my spill range formula. Variable "result" in the LET is populating the cells. I am struggling to define variables prevAmtRows and PrevAmtColumns which are assigned a value of 999. What l need PrevAmtRows to do is to calculate the values returned by result in the previous rows of...

TextSplitVar is a recursive formula to split a single cell or text array by the delimiter and return the variable chosen. It checks the number of variables and provides the last variable if the user asked for too large a number. It also adds one more delimiter at the end on the first iteration...

I have a model containing some internal code that I want to be able to programmatically remove from the model before saving it as an "external" version. I searched and found code to remove an entire module that works great. However, now the resulting "external" file gets compiler errors when...

Hi folks, I have been using a neat bit of code I found on Mr. Excel to take two columns of information and return an array of the possible, non-recursive combinations. The code is below. Below that is a mini-sheet to help what I am trying to get to. I would like to have only the array with...

Hello there! Currently, I have a Userform with a textfield that is validated once the "Submit" button is clicked. There are two possible outcomes: 1) The textfield value is valid and the form closes. 2) The textfield is not valid, and the user must continue filling or editing the form...

Hi, I have Data table which has data as shown below In this I need to get the "Component" data which are structured under "Item" and after that each component will be considered as "Item" and recursive CTE comes here. Please help me to sort this out. Sample Input: Sample Output in...

This LAMBDA provides a recursive loop to extract subarrays of given set of dimensions, or warns the user if their provided dimension(s) are bigger than their target array; I am returning the list of the subarrays using ARRAYTOTEXT, but this could be substituted with another function to suit the...

Can someone help me find a shorter formula. I would like the corresponding row's first column to appear in successive columns in a second sheet. Each F number (ie F1, F2, etc) refers to a person. the cells to the right of each person refer to a job that they will be doing (ie Team 1, Team 2...

Hi! I had a set of ~50 project folders (format e.g. 12345_Project_Name) which mere migrated to another server, but in the process were moved into different subfolders and in some instances were renamed, so I cant, for example, simply rename hyperlinks from \\drive_a\ to \\drive_b\. I've pulled...

I have a table with Bill of Material information in four columns; Parent PN, Child PN, Quantity, Units of Measure. Given a parent part number as an input I am returning the "exploded" or "indented" bill of material. Essentially that means I am returning all the children of the parent, all the...

Hello , I have a vba code which captures the data every 20 second from a dynamically changing cell value and stores in the sheet along with some calcuations using Application.Ontime In the sheet , on checking the difference with the timestamp, show data has been entered at 20 seconds most of...

Hi there, I already have VBA code that will recursively trawl through a directory. I am currently using this to identify if any columns in any of the worksheets in any of the Excel workbooks within that directory contain email addresses and, if so, those columns are then deleted. Here's the...

I have an organizational chart that has approximately 15000 employees and is about 8 layers deep. I'm trying to associate all employees to their respective "Vice President". So far I've got a recursive vlookup but it seems unstable and messy. I've tried also creating an index table, but...

Hi, I have been creating folders in Outlook using a simple macro that creates folders from the first column of an Excel sheet under the folder currently selected. That macro is based in Outlook. We are at the beginning of a new fiscal year and I would really like to create the whole tree at...

Hi all, I'm looking for a simple code that can obtain the properties of a windows folder. On windows if you right click a folder and go to properties you can obtain the number of files/number of folders etc. in a few seconds. However, if you use the recursive method of looking through each...

I have written an SQL query to bring BOM data into Excel from Sage 200. I am now trying to make the query recursive so that I can have a single listing of all the components used in a build. This will update an existing spreadsheet which brought in all this data from our older system The key...

I usually have difficulty explaining my issues on access but I do need some some assistance/expertise from this glorious forum in order to make my life easier at work, so here it goes: Basically, I started a job a few months ago and there is a spreadsheet (in Excel) with (firstly) 6 columns of...