i want a way to make changes in data model with vba in powerpivot

[SanjivManiktala]

i recorded a macro that create a pivot table but the change i make with manage data model are not recorded, so i have to make changes in data model manually in powerpivot manage data model, then again i recorded the rest of what a pivot table does.
so i want a way to make changes in data model programmatically