August 21, 2014 at 12:17 pm
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
August 21, 2014 at 2:41 pm
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.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply