dictionary

I want to create some dictionaries that i can access in any workbook. I.E a list of colors as the key and a list of shortened versions of that color. Gloss Black White Trim = key Black = Value i have a sheet with these values that i would like to establish as a disctionary A: will this work if...

I know these appear really fast, I have a worksheet that grows every day and currently 98% has to be looked up manually (basically a location, that then develops into postcode ad easting & northing plus A&B identifier's In the table shown as A I am developing values in Col AN I want to keep...

I would like to know if creating these two objects while on a MAC would create an error that can be used to adjust the workbook accordingly. Thank you for your time.

I'm currently having a problem where an auto-filtered range is only placed inside an array on the first loop but subsequent attempts to do the same despite the range filtering correctly don't work. Set OpenWBS = Workbooks(Workbooks.Count).Worksheets(1).UsedRange...

This is probably something simple but I just wanted to know all my available options. I own and maintain a data dictionary that I keep on Excel. There are around 12 columns, all with headers. The columns are meant to identify all the attributes of a particular data element. Each row is a...

I found below code to VLookup with cell format, it works only when you add "Microsoft Scripting Runtime" library to the workbook's VBA Project (via. Tools > Add > References) However, to remove the need to add above library, I modified a part of the first code as below, but It Does Not Work...

Hey all, I have a CSV file with the following data in rows: <tbody> {'gender': 'male', 'age': '35', 'hometown': 'Chicago', 'car': 'Civic', 'occupation': 'actor', 'salary': '80000'} {'gender': 'male', 'age': '32', 'hometown': 'New York', 'occupation': 'banker', 'salary': '130000'}...

Hi, is it possible two have two keys for each value? Here's the problem I'm facing with. I have some balance sheets for different people with different dates in different worksheets and files. I want to extract certain data such as the numbers of equity or debt from balance sheet, and rearrange...

I have a set of data: Domains; Users; Machines I have a task that requires me to check to see if a domain user has logged into a particular machine in the past. There are unlimited domains, an undefined number of users, and the machine name could potentially change at any time. The tool has to...

I have Dim MyDict As Dictionary at the top of a module so that it can be used by multiple functions. How do I enable the values in MyDict to remain in memory when I use MyDict.Add appAccess.currentproject.Name, appAccess so that I can use the values in MyDict in separate functions within...

Hi I can print Dictionary values to the immediate window by running the code below, but I wanted to know how I print "all" the Dictionary values into an Excel sheet? Public Sub DictionaryExamples() Dim exampleValues As Variant Dim i As Long Dim aKey As String Dim aValue As...

Hi All, I am trying to use the NVD database JSON files (available to download from https://nvd.nist.gov/vuln/data-feeds - ) so I can construct a sheet of all the vulnerailities and then I can sort them in Excel. Yes, I realise that NVD does offer a search function so I could limit it to Oracle...

hello all, Normally I would use Index/Match but I'm looking for a VBA solution. In column A I have a list of numbers. In column B I have a list of names. In column C I have a date. Can a scripting dictionary have 2 keys (in column A & B) and 1 item (in column C)? Match the value in columns...

I have a table with several thousand foreign words (Hrvatski to be precise which is spoken in Croatia) which is mixed with a few English words. What I need to do is delete all the words in this table (words are in columns A-D) that are NOT found in the English Excel dictionary. In other words...

Hello, I am looking for some assistance in using a Scripting Dictionary to read a column of data and store unique values for output into a list. The problem i am coming across is the Scripting Dictionary is parsing lines in separately when it sees a comma. For example: AL - Medical Group...

Hi, I declared a variable as dictionary. Wonder if there is a way to check if anything been added to the dictionary. I have the following code but it says that the dictionary is NOT EMPTY. Sub store_Dict() Dim Dict_curUpdate As New Dictionary If Not Dict_curUpdate Is Nothing Then...

I am getting an object required error when I run the following code: Sub Schedule15(theDictionary As Dictionary) Dim singleKey As Variant For Each singleKey In theDictionary.Keys() Debug.Print theDictionary.Item(singleKey).Country Next singleKey...

I am doing a dictionary check, the code works with loops, but is way to slow. I got it running with dictionary as well, however a problem appears, when the same value is already in my result matrix. Several values in my arrSource are going to appear once or twice and I want to know EVERY time...

Hi, how do I add a range to dictionary using VBA? As an example shown below, using Product as key and Order as value: <tbody> Product Order Chair 10 Table 5 Pencil 20 Pen 30 Printer 1 Phone 5 </tbody> Thank you!

Hello fellow developers. I would like you to give feedback on this macro I coded. educational value: the code contains comment lines to explain various coding techniques. Did it help to understand how some things can be done? Working with a dictionary Return multiple values from a function...