VBA - Dictionaries

preview_player

Показать описание

This video discusses the use of dictionaries in MS Excel VBA code.

Frankie Skaggs

Рекомендации по теме

Комментарии

Hi, I am trying to fill in a dictionary with data from SQL server 2008, this is my code :
Query = "select frameID, siftSize from framesDef"
'Query of selection
cmd.CommandText = Query
Dim res = cmd.ExecuteReader()
While res.Read()
sic.Add(res("frameID"), res("siftSize"))
res_lab.Text = sic.Count
'Just to test the dictionary
End While
it is displaying an error
someone help please ?

nagisafurukawa