Hi all,
I have a workbook that has a Master Data Services connection which i use to maintain a list of items and their attributes - at the moment it's very manual and time consuming so I am looking to add some automation.
In essence, changes to the list are emailed to me, I then collate them and use a vlookup on the Master Data entity and copy / paste the new values on top.
What I am looking to do is create a macro to do the following
1) Connect to the MDS server / model
2) Refresh the relevant Master Data list
3) Take the changes from a consolidated list and copy over the top of existing attributes
4) Publish the changes and commit them in to the MDS database
I am totally stuck, have tried to record a macro and get the relevant code that way .. but that doesn't seem to want to work and either am not searching for the right thing in google, or there is nothing out there.
Any help / advice / guidance would be GREATLY appreciated
I have a workbook that has a Master Data Services connection which i use to maintain a list of items and their attributes - at the moment it's very manual and time consuming so I am looking to add some automation.
In essence, changes to the list are emailed to me, I then collate them and use a vlookup on the Master Data entity and copy / paste the new values on top.
What I am looking to do is create a macro to do the following
1) Connect to the MDS server / model
2) Refresh the relevant Master Data list
3) Take the changes from a consolidated list and copy over the top of existing attributes
4) Publish the changes and commit them in to the MDS database
I am totally stuck, have tried to record a macro and get the relevant code that way .. but that doesn't seem to want to work and either am not searching for the right thing in google, or there is nothing out there.
Any help / advice / guidance would be GREATLY appreciated
