Can we automate moving data/images from Excel to powerpoint while changing the fonts of the data. Any suggestions…
Hi! That’s an interesting challenge we don’t have support for out-of-the-box, but I believe you can do it like following:
- Build a VBA script (or Macro) which exports the cells into PowerPoint.
- Then extending the
RPA.Excel.Applicationlibrary and fiddling with the
self.appobject so you can run the script.
a. Our Run Macro might already support this. (Microsoft docs)
- How to Automatically Copy From Excel to PowerPoint Using a VBA Macro | It Still Works
- Exporting data from Excel to an existing PowerPoint slide using VBA - Stack Overflow
Let us know what was the solution and good luck!
@cosmin, Thanks for the response, will go through the docs and see what works.