In reply to Michael Schmidt.

Yes, PowerShell or other scripting is the only solution I can think of for automating local Excel.