-
Recent Posts
Recent Comments
Patrick O'Beirne, Ex… on Excel formula to test if a wor… Peter Bartholomew on Excel formula to test if a wor… Rick Rothstein on Excel formula to test if a wor… Patrick O'Beirne, Ex… on Excel formula to test if a wor… Peter Bartholomew on Excel formula to test if a wor… Archives
- Mar 2023
- Feb 2023
- Oct 2022
- Mar 2022
- Jan 2022
- Dec 2021
- Nov 2021
- Oct 2021
- Aug 2021
- Jul 2021
- Jan 2021
- Oct 2020
- Sep 2020
- Jul 2019
- Jun 2019
- Apr 2019
- Jul 2018
- May 2018
- Apr 2018
- Mar 2017
- Feb 2017
- Jan 2017
- Sep 2016
- Aug 2016
- Jun 2016
- Apr 2016
- Jan 2016
- Sep 2015
- Aug 2015
- May 2015
- Oct 2014
- Jul 2014
- May 2014
- Apr 2014
- Jan 2014
- Sep 2013
- Aug 2013
- Jul 2013
- Apr 2013
- Mar 2013
- Feb 2013
- Nov 2012
- Oct 2012
- Jul 2012
- Jun 2012
- May 2012
- Mar 2012
- Feb 2012
- Jan 2012
- Dec 2011
- Nov 2011
- Oct 2011
Categories
Meta
Tag Archives: Excel
ChatGPT 3.5 Excel script
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 Excel, scripting, A.I., ChatGPT, Officescript, Typescript, openai
Leave a comment
VBA Application methods compatibility in Excel and Access
When working on VBA code that should work in both MSExcel and MSAccess VBA, the different application object methods can be hard to manage. For example, Application.Screenupdating = False is used in Excel but would raise a compile error in … Continue reading
Excel questions at the Financial Modelling Summit 2022
Slugify text We want to slugify text, ie include only characters a-z, 0-9 and “-“, so that it can become part of an URL. So that for example “Why I say ‘Bazinga!” – my #1 Reason for Using =INDEX(MATCH())!!” Becomes … Continue reading
WordXLe: Wordle in Excel
An Excel version of the word game Wordle, with helper sheets. Continue reading
XLTest 1.74 spreadsheet audit addin
I have released an update to my XLTest Excel add-in for spreadsheet auditing, visualisation, and testing. Changes up to version 1.74 (September 2021) Start Session dialog changed to show internal workbook information before opening, and to open in manual calculation … Continue reading
Excel Virtually Global 2021
I am one of the 48 speakers at a 48-hour Excel extravaganza online on Oct 12 and 13. It’s FREE but you are encouraged to make a donation to charity to reflect the value to you of the content you … Continue reading
Posted in Uncategorized
Tagged CSV, Data, Excel, ExcelVirtuallyGlobal, StructuredData, Unicode, VBA
Leave a comment
Event Tracing is three times faster than OutputDebugString
I use the OutputDebugString API in Windows to send debugging messages without the line limitations of the VBA Immediate Window. This is also useful when tracing the causes of crashes which kill the Excel process. I use TraceSpy to capture … Continue reading
Querying Text/CSV files in VBA, method #3: Power Query
The module PowerQueryText.bas contains VBA code to query text/csv/tab delimited files and return tables to worksheets. Continue reading
Hello (the rest of the) World – reading data in other languages
Have you ever opened a text file in Excel and found that the characters looked weird or corrupted? The Wikipedia entry for mojibake says ‘In German, Buchstabensalat (“letter salad”) is a common term for this phenomenon, and in Spanish, deformación … Continue reading
Conditional compilation VBA Excel Mac/Win/32/64…
To make my addin handle all the combinations of Excel 2007 onwards on Mac and Windows, 32-bit and 64-bit, I ended up with this conditional compilation block. The example I use is GetTickCount() but the principle applies to other declarations. Microsoft … Continue reading