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”
In this article, I will show you how to open an ODC file in Excel, or create one if you need to.
What is an ODC (Office Data Connection) File?
An ODC file contains the information related to an external data query created with Power Query (also known as Get & Transform) in Excel. The ODC file can be used separately from the workbook file to share the query without sharing the rest of the data in a workbook. This way, queries can be shared across different workbooks where you may want to use the query. For instance, you may have a query to get the latest bitcoin prices. By creating (or using) an ODC file, you can set this query up once and use it in one workbook to make price forecasts and another to monitor the value of your personal portfolio.Continue reading “Excel 365 Save or Open an ODC File”