Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to mark an Excel cell as changed so its value will be published to Master Data Services? Expand / Collapse
Author
Message
Posted Thursday, August 21, 2014 12:17 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, September 12, 2014 2:11 PM
Points: 26, Visits: 70
I am writing some Excel VBA code to go along with the MDS add-in so our users will have an easier time sorting, filtering, and publishing data.

The code I wrote populates some cells with data from another sheet whenever the user makes a change in a certain column. The code is working and populating the correct cells with the right data; but, when I press publish the newly populated cells do not publish.

I have noticed that the cells do not change color when they are automatically populated by the procedure. Is there a procedure, method, or something that I can use on these cells to make MDS see that there has been a change so that they will be published when the publish button is pressed?

The code I am using to populate the cells looks like this:

Cells(RowNum, ColNum).Offset(0, 5) = Category
Cells(RowNum, ColNum).Offset(0, 7) = Style

Post #1605959
Posted Thursday, August 21, 2014 2:41 PM This worked for the OP Answer marked as solution
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, September 12, 2014 2:11 PM
Points: 26, Visits: 70
It looks like I figured it out.

I had Application.EnableEvents set to False in the code which was preventing the cells to be marked as changed for MDS. I simply put
Application.EnableEvents = True

before the code that populates the cells with the data. Now the newly populated cells are highlighted and ready to be published to MDS.
Post #1606009
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse