User Profile
JerryDNYC
Copper Contributor
Joined 5 years ago
User Widgets
Recent Discussions
VBA to delete Power Query Connections or Folder
I have a master workbook with 10 Power Query connections. That workbook is a Read-Only file, and has a macro that saves the workbook with a different file name. Once the file has been saved I want to delete all the queries. I've tried using ActiveWorkbook.Connections("Query - Report").Delete but it's not deleting the queries. Is there something else that needs to be done before being able to delete a query? Incidentally, all 10 queries are contained within a query folder named Reports. I am able to right click on the folder and delete all the queries that way. Unfortunately the VBA recorder doesn't record that action or the deletion of individual queries. I'd rather just delete the folder in VBA if that's possible. Thanks.Solved18KViews0likes9CommentsExcel Version 2204 Insider 3/16/2022 - ScreenUpdating Macro problem
I have a file I use daily that has a macro that starts with Application.ScreenUpdating = False to stop the updating of the screen because the macro switches to a few other worksheets. Of course, the value is set to True at the end of the macro. Yesterday I received the Insider Update (that added 14 new functions!), and now when the macro executes that line of code, the entire worksheet area - between the formula bar and status bar - goes blank! I tried running a repair on Office, but the problem persists. Anyone else seeing this?1.5KViews0likes0Comments
Groups
Recent Blog Articles
No content to show