Editing an Excel Embedded Object in Powerpoint with VBA from Access
Posted on 2016-08-24
I have a whole process that updates various objects in Powerpoint using data and an Access module.
I have successfully updated chart data, text boxes and tables. The issue lies with an embedded Excel spreadsheet. I need to update the data in the Excel embedded spreadsheet but for some reason it is not updating the data.
The portion of my code that is supposed to update the Excel is this...
.Worksheets(1).Range("J11").Value = "50"
It doesn't error out but it does not actually update the cell value (previously in the code the PowerPoint file is opened and moved to the correct slide (currentSlide is the variable that references this and strObj is the variable that is feeding in the name of the object to be updated). It works well every where else that I am updating something.
Do I have to use something other than activate? Is there an update method or something that I have to use?
Any help would be greatly appreciate.