In this article, I offer two different ways to loop through rows of a table or range in Excel VBA. Looping through rows is a common task in VBA so it’s good to have a strong grasp of the code.
Continue reading “Excel VBA Loop Through Rows in a Table or Range”Tag: vba
Save Excel Table to JSON File using VBA and VBA-JSON
While importing JSON files to an Excel Table is easy using a Get and Transform query, going the other way and saving an Excel table as a JSON file is unfortunately not as simple. Luckily, with the code below, it’s easy to save the first Excel table in your sheet as a JSON file.
Continue reading “Save Excel Table to JSON File using VBA and VBA-JSON”