Post

Office Automation

Automate Excel, Word, Powerpoint

Excel Automation

  • Report Generation
  • Data manipulations, Data Clean Up
  • Data Import/Export CAD,FEM Model, CSV, PDF, Text, XML, JSON
  • Custom Formatting with VBA Macro, Conditional Formatting
  • Custom User Forms
  • Advanced Custom Formula, Custom Function with VBA

Excel automation is done using VBA, C#, or python.

Word Automation

  • Report Generation from excel data
  • Formatting automation
  • Custom Report Builder using User Forms

Word automation is done using VBA or python.

PowerPoint Automation

  • Report Generation using excel data.
  • Extract Data from PowerPoint Text/Slide Images to Excel using VBA Macros.

PowerPoint automation is done using VBA or python.

I only do office automation for windows version of office. I don’t provide any automation service for Mac version. If you’re planning to use my automation on windows and mac both it might not work due to difference in functionality. Additinally windows and mac both have different file system so if your project code depend on that you’ll need separate code for that.

This post is licensed under CC BY-NC-ND 4.0 by the author.