Stack Overflow
Stack Overflow

Questions tagged [scripting.dictionary]

26 questions
1
vote
2 answers

ASP: Reading Scripting.Dictionary with ADODB.Command Result

I'm trying to query the userAccountControl from Active Directory and match it against a dictionary that I've set up in my script. First of all I set up my dictionary object and fill it: dim uac Set…
Blind Trevor
  • 746
  • 2
  • 9
  • 28
0
votes
1 answer

SUMIFS faster in vba array and scripting.dictionary

I want to use the vba sumifs array and scripting.dictionary because there are a hundred thousand records there may be the best solution. For information sheet "DBALL" is the source and sheet "RECON" is the result. I also found the vba code below but…
roy
  • 693
  • 2
  • 11
0
votes
1 answer

VBA webResponse Response.data getting error when changing type from "Dictionary" to "collection"

Here is the problem : I have the following code Dim Client As New WebClient Dim Request As New WebRequest Dim Response As WebResponse Dim responseData As Scripting.Dictionary Request.UserAgent = VBA.Environ("USERNAME") Request.AddHeader…
NASSIM ADRAO
  • 145
  • 1
  • 9
0
votes
1 answer

VBA - Object Required Error, Altering Object from Dictionary

I am programming a kind of parser which reads an Excel table and then creates a List of processes with some properties like Name, StartTime, EndTime etc. For this I have a class Process and in the main file, I have a processList…
Rionick
  • 11
  • 2
0
votes
1 answer

using scripting dictionary to find values, then print key

So with help from others after asking a few questions, I am now at the point where I have the below VBA script for a Macro. It references a master list of customer codes and what group they stand for (worksheet "CustomerCodeReference"). It's…
DJCrowen
  • 17
  • 4
0
votes
2 answers

UserForm Identifying Correct Sheet Based on cobo Value

I have a workbook that houses Client information. There is a sheet for each Client, and each sheet is labeled with the Client's unique ID. I'm wanting to launch a UserForm where the User will select a Client from a cobo box. Then, data from the…
Rodger
  • 11
  • 2
0
votes
1 answer

How do I append to an array that is a value of a key in a dictionary?

If I set up a dictionary as such: set myDict = CreateObject("Scripting.Dictionary") I ask a user his name. Wscript.StdOut.WriteLine "What is your name: " name = Wscript.StdIn.ReadLine I then ask the user for five numbers. Wscript.StdOut.WriteLine…
Douglas C Howe
  • 103
  • 1
  • 2
  • 9
0
votes
1 answer

Class does not support Automation or does not support expected interface

I'm importing a kind of CSV security file for reporting in Excel. The file basically has the following format: !Users UserA UserB UserC ... !Roles RoleA RoleB RoleC ... !Permissions UserA|RoleA UserA|RoleB UserC|RoleA UserB|RoleC ... The report…
neelsg
  • 4,802
  • 5
  • 34
  • 58
0
votes
1 answer

VBA Scripting.dictionary run-time error '13' type mismatch

I have written code to go through two columns, one will be the key and the other item/items. It goes through and finds the keys, if it finds a duplicate it adds it to the items along with the previous item. The problem comes when I try to print…
PIPetro
  • 1
  • 4
0
votes
1 answer

Scripting.Dictionary keys to Listbox VBA Excel

I have been working with VBA in excel and recently began working with the Scripting.Dictionary object. I hadn't run across any major problems until today. Basically I am trying to populate a listbox with the Key values of a dictionary, then add one…
user2376393
  • 1
  • 1
  • 1
0
votes
1 answer

Scripting.dictionary to c#

Facing one problem please help me.... We are product development company and our existing application is in ASP, I am trying to send scripting.dictionary object to c#'s com visible class. I am using the System.Collections.Generic class here is my…
naresh
1
2