Hey community!
I've come to the limit again that I have to use VBA. Unfortunately, my abilities with VBA are exhausted.
I have a file that should overwrite selected tables in new or old Excel spreadsheets after updating all PowerQuery connections.
So I have TblTotal. This has a total of 10 tables. TblOne - TblTen.
After the refresh, TblOne-TblThree should be saved or overwritten in "DashBoard_A".
TblFour-TblSeven in "Dashboard_B".
TblEight TblTen in Dashbaord_Ex.
If the dashboards are open, new Excel spreadsheets should be created with the date, otherwise they should be overwritten.
Does one of you know how to do that?
greeting
Joshua
I've come to the limit again that I have to use VBA. Unfortunately, my abilities with VBA are exhausted.
I have a file that should overwrite selected tables in new or old Excel spreadsheets after updating all PowerQuery connections.
So I have TblTotal. This has a total of 10 tables. TblOne - TblTen.
After the refresh, TblOne-TblThree should be saved or overwritten in "DashBoard_A".
TblFour-TblSeven in "Dashboard_B".
TblEight TblTen in Dashbaord_Ex.
If the dashboards are open, new Excel spreadsheets should be created with the date, otherwise they should be overwritten.
Does one of you know how to do that?
greeting
Joshua
