How Can I Automate Excel Using KM?

I would say that in general it is very possible to automate Excel using KM, and maybe some AppleScript. Unfortunately, it is not possible to offer you more specific suggestions without much more detailed info about your workflow, and exactly how you want to automate Excel.

So, if you'd like some specific suggestions, you need to:

  1. Post a step-by-step process of your workflow
  2. Post your existing macro
  3. Upload an example Excel file (as a zip file), and show us (a video would be great) of how you want to automate your use of it.
  4. Post an example (screenshot) of the Excel screen before and after you make changes.

Please read:
Tip: How Do I Get The Best Answer in the Shortest Time?