Questions tagged [scripting.dictionary]
26 questions
5
votes
3 answers
Dictionary/Client VS Application Variables
Hi i got a question about my server performance ... i got a classic asp cms hosting ~250 websites, for each website we build a Classic ASP dictionary using
set dict = CreateObject("Scripting.Dictionary")
dict.add "test1","Value Test1"
dict.add…
Lil'Monkey
- 991
- 6
- 14
4
votes
3 answers
Using a dictionary object in application scope in Classic ASP
Following up from my last question does anyone know how I can use a dictionary object in application scope in Classic ASP? You cannot use Scripting.Dictionary - if you try you will see something similar to the following:
Application object error…
joshcomley
- 28,099
- 24
- 107
- 147
3
votes
2 answers
Scripting.Dictionary Lookup-add-if-not-present with only one key search?
I am looking up keys in a Scripting.Dictionary to make sure I add them (and their items) only once to the dictionary:
If MyDict.Exists (Key) Then ' first internal key-value lookup
Set Entry=MyDict.Item (Key) ' Second internal key->value…
TheBlastOne
- 4,291
- 3
- 38
- 72
3
votes
2 answers
Excel VBA: Scripting.Dictionary Calculations
I have the following values in a spreadsheet:
Printer Name | Pages | Copies
HP2300 | 2 | 1
HP2300 | 5 | 1
Laser1 | 2 | 2
Laser1 | 3 | 4
HP2300 | 1 | 1
How can I get the total number of pages printed…
r1pster
- 147
- 1
- 12
2
votes
1 answer
How to initialise CComSafeArray which a SAFEARRAY returned from a Scripting.Dictionary Keys method
I'm using a Scripting.Dictionary from the COM Library "Microsoft Scripting Runtime" (c:\windows\System32\scrrun.dll). I'm using import to get my wrappers and these are working. After adding some items, I'm trying to get the list of keys but I am…
S Meaden
- 8,050
- 3
- 34
- 65
2
votes
2 answers
How to add an array into an in cell dropdown from a scripting dictionary?
I have a data dump from different application. I want to get unique values from a singular column in the data dump (which has variable length). Once I have the unique values I want them to be called into an .incelldropdown from data validation. I've…
Antonio
- 57
- 8
2
votes
1 answer
Store all the items from a HTML table in to a Scripting Dictionary, adding also the duplicates values
I want to store in a dictionary all the items found in a html table.
I have problems when I have duplicates, because my below code don't store again the item, and I need all the items from this table, even if there is any duplicate.
If I have…
Flo-Rin
- 107
- 1
- 8
2
votes
1 answer
scripting.dictionary doesn't recognise numbers
got this code:
Dim a, i As Long
With Range("K1", Range("K" & Rows.Count).End(xlUp))
a = .Value
End With
With CreateObject("Scripting.Dictionary")
.CompareMode = vbTextCompare
.Add "test", 1
For i = 1 To UBound(a, 1)
If…
Richard
- 91
- 1
- 3
2
votes
1 answer
VBScript: Sorting Items from Scripting.Dictionary
I have the code below... it grabs data like this:
name1, name4, name2, name3
and list like this ([ ] is a checkbox):
[ ] name 1 [ ] name 4 [ ] name 2 [ ] name 3
<%
Set DicionarioMyData = CreateObject("Scripting.Dictionary")
Set MyData=…
Khrys
- 2,670
- 9
- 49
- 82
1
vote
2 answers
How to watch a "Scripting.Dictionary" of more than 256 elements in excel vba when adding a variable in the spy window?
I have a scripting dictionary of around 450 elements. I need for debugging to watch in the spy window elements at index > 256, but Excel VBA limits the view to index 256. What I want to debug is the lack of some keys and to track what happens when…
lalebarde
- 1,684
- 1
- 21
- 36
1
vote
2 answers
How to transpose scripting dictionary keys and retain "05" and "5" as two distinct values?
I created a table to include/exclude distinct values from a larger dataset. This table is made with a scripting dictionary.
The dataset could contain numeric values as a parameter which should be considered as a textual value.
Example: "05" and "5"…
Fabian_W
- 11
- 1
1
vote
0 answers
type mismatch when assigning scripting dictionary values to array
Hi all this is likely a simple syntax error but I am trying to use a variant/string array stored in a scripting dictionary (early binding). I have tried a few methods (moving it to a tmp array using the key and calling the values straight from the…
Nathan Dick
- 11
- 3
1
vote
2 answers
VBA Extra key/item pairs in scripting.dictionary
This code was working for several days, looping through a dictionary just fine. The loop started breaking, and I have extra keys in the dictionary and I have no idea where they came from.
I am creating a scripting.dictionary with the following:
Dim…
lukehawk
- 1,423
- 3
- 22
- 48
1
vote
1 answer
VBA Rewriting Array in scripting.dictionary
I am trying to create a dictionary, with each key being a name I created, and each item an array of three objects: a string, an integer, and an array of what will be the results from a SOAP request.
I initialize the array like this:
Dim riskDict As…
lukehawk
- 1,423
- 3
- 22
- 48
1
vote
0 answers
C++ and Scripting.Dictionary from scrrun.dll
I have some trouble with Scripting.Dictionary in C++.
I'm trying to use interface IDictionary via smart pointer but methods of creating object don't work and I can't understand why.
CoInitialize(NULL);
IDictionaryPtr…
shadeglare
- 7,006
- 7
- 47
- 59