dictionary

Hey, I have a macro that loops thorugh a list of supplier codes on a worksheet and checks each one to see if that number appears in a text file. The text file represents a subset of supplier codes based on location, and as such is frequently updated. Currently, I'm importing the data from the...

Hi I am wondering if there is a way with VBA to extract words from online web dictionary in two languages the word and its meaning with all of the pages into microsoft excel , Is there a code or can someone make it please :( Example of site : http://www.billydilly.com/en/english-arabic/a

I have a spreadsheet with 3 columns. Column A contains product type names with the range named as "Product".Column B is a description of the product names and Column C contains supplier names with the range named as "supplier". I'm using a macro based on a Dictionary object to extract a list...

hi, I'm using Scripting Dictionary to make unique list: Dim count_result As Long count_result = 0 Set dict = CreateObject("Scripting.Dictionary") For i = 3 To last_row looking_string = wsC.Range("O" + CStr(i)).Value If Not dict.exists(looking_string)...

Hello, I have a function designed to update a Dictionary object. All works well, but now I want to make the function more generic by having it instantiate a new dictionary object by passing a name. The motive is to use the function across different dictionaries. The problem is that the vba...

Hi Guys, can I add a range or an array as an item to a corresponding key? Lets say I have a spreadsheet where Column A has values that populate my dictionary Keys and columns B:D contain the item. So if I used the "Add" method,it would look like this: D.Add Key:=Value Item:Values in the row...

Hello coders! I am a teenager at my first internship and I've been tasked with producing an excel file that with the push of a button turns a whole bunch of text into a wordlist of the most frequent words, in array format. So far I've successfully managed to scan separate words into an array...

I was wondering if anyone could help me out. I have a large dataset that I need to push into a dictionary, into that dictionary I also have to create other dictionaries and this can go on until I fill the entire dataset into the dictionary. The problem is that I do not know beforehand what the...

Hello Friends Is it possible to add values to array or dictionary that can be used as a look up list? I would like to add following list and later check if certain value starts with values in this list or not. FP-* TJ-* TP-* WP-* BR-* HS-* I am not sure if adding wild card "*" to the list is...

I wish to compare two worksheets and remove all the rows from worksheet 1 where there is no corresponding row in worksheet 2. I wish to compare column C in worksheet 2 starting at row 8 with column B in worksheet 2 starting at row 2. I have almost got it working, except that I have to run the...

I am trying to leverage code written by programmer that is far beyond my own ability. The objective of this routine is to determine whether a balance exists in two variable combination(Fund and SRC). The fund and source is determined from a loop on wksProcessData. wksprocessdata example...

Hi... I have built several items in my dictionary called Tdic. TDic("MSL") TDic("MS") . . etc If I wanted to know how many iems are in Tdic, I can do: DicCount = Tdic.count I'm having problems determining what name I gave at each item in Tdic. I've tried: TName = Tdic.Item(1) the...

I've looked for the answer to this but not really seeing it. Seems like every related topic I see discusses how to use autocomplete with one document. I get that. And I use it but that only works once you've already typed that word once in the document, right? Can I have Excel remember words...

Hi, Forgive me if this is a simple question. I am a novice and have been battling with a dictionary item retrieval issue for quite a while, spent days searching the internet for an answer and have given up in favour of posting my own question. Any help will be very much appreciated. My issue...

Hello I'm quite comfortable with building an array from a Project file, 25 columns wide and 10000 rows long, then dumping it into an Excel Spreadsheet. I'm now essentially doing something similar in reverse though. I have a uniqueID-type column as column1 in the excel spreadsheet, and need to...

Hi, for people using their Excel in other languages than English - Excel 2007 functions and their descriptions in 14 languages: http://www.piuha.fi/excel-function-name-translation/ Why? I needed an updated look-up table because at home I'm using my Excel 2007 in Finnish and I don't have a...