Forum

VBA to "Sort by Col...
 
Notifications
Clear all

VBA to "Sort by Column" in the Data Model

3 Posts
2 Users
0 Reactions
98 Views
(@matthias)
Posts: 49
Trusted Member
Topic starter
 

Hello,
Is there a way to use VBA to define "Sort by Column" in the data model (e.g. month name by month number)?

Thanks,
Matthias

 
Posted : 01/12/2022 8:37 pm
(@catalinb)
Posts: 1937
Member Admin
 

Hi Matthias,

There's little control of the data model from VBA, mostly because data modelling is not a simple process.

If you go to Object Browser in vba, (F2 shortcut from VB Editor), the Model object is the object you are looking for.

I checked all child objects, but there is no sort method on ModelTable or ModelTableColumn objects:

image_2022-12-02_202640303.png

 
Posted : 03/12/2022 2:27 pm
(@matthias)
Posts: 49
Trusted Member
Topic starter
 

Hi Catalin,

thanks for the efforts! And that is a marveous idea to check the Object Browser. For data modelling there is almost nothing to find with Google.
So the Object Browser is a great way to check out if there is anything available!

Thanks again,
Matthias

 
Posted : 03/12/2022 10:20 pm
Share: