Tag Archives: scripting

ChatGPT 3.5 Excel script

Posted on Mar 15, 2023 by Patrick O'Beirne, Excel/VBA developer

Everybody seems to want to use AI to create Excel formulas, so here is a way of building an interface to the OpenAI ChatGPT 3.5 model. Leila Gharani has already published a video and the Office Script code to call … Continue reading →

Posted in Excel/VBA | Tagged , , , , , , | 1 Comment

Dictionary VBA Class update

Posted on Nov 24, 2011 by Patrick O'Beirne, Excel/VBA developer

I’ve uploaded a new version of the Dictionary Class and a helper KeyValuePair Class. This exposes the KeyValuePairs collection so iteration is now very fast, about 2 seconds to iterate 1 million items using a for each loop:   dim oKeyValuePair … Continue reading →

Posted in Excel/VBA | Tagged , , , , | 55 Comments