image

How to Refresh Data Connections in Excel VBA

Quick reference: The first one will “refresh” only one file. The second will “refresh” all open excel files. ThisWorkbook.RefreshAllActiveWorkbook.RefreshAll  With the release of integrated stock pricing in Microsoft Excel, it was unfortunate there wasn’t any sort of setting that allowed for automatic updating of the stock data while the file was open. Even worse, there Read More

image

How to Set up Cross-Report Drillthrough in Power BI

With the Power BI cross-report drillthrough feature, you can contextually jump from one report to another report in the same Power BI service workspace or app. You can use cross-report drillthrough to connect two or more reports that have related content, and to pass filter context along with the cross-report connection. To initiate cross-report drillthrough, you select Read More

image

How to Use Excel VBA Autofilter: A Complete Guide with Examples

A lot of Excel functionalities are also available to be used in VBA – and the Autofilter method is one such functionality. If you have a dataset and you want to filter it using a criterion, you can easily do it using the Filter option in the Data ribbon. And if you want a more advanced version of Read More

image

How to Get Current Working Directory Using VBA

Use Application.ActiveWorkbook.Path for just the path itself (without the workbook name) or Application.ActiveWorkbook.FullName for the path with the workbook name. CurDir() is also very useful in some circumstands For example, When you open an Excel document D:\db\tmp\test1.xlsm: CurDir() returns C:\Users\[username]\Documents ActiveWorkbook.Path returns D:\db\tmp So CurDir() has a system default and can be changed. ActiveWorkbook.Path does not change for the same saved Workbook.