Notifications
Clear all
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
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:
Posted : 03/12/2022 2:27 pm
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