Next, we need to build our VBA for refreshing the table. Let’s sort Animal ascending (just so we know something happened)Īt this point, we should get a new “Sheet2” worksheet, with our table on it:.Let’s just grab the sample data file from my post on pulling Excel named ranges into Power Query. The interesting part about the above statement is that Power Query doesn’t have any VBA object model, so what kind of black magic trick do we need to leverage to pull that off? As it turns out, it’s very simple… almost too simple in fact. The last thing I want to do is to send them right clicking and refreshing everywhere, so I program a button to refresh Power Query with VBA. When I’ve finished building a solution in Excel, I like to give it a little polish, and really make it easy for my users to update it.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |