I sure am getting in the habit of reacting to other blog posts more than writing original content, but hey, it is working for me, so here is today’s:
The pertinent quote that caught my attention was:
But if you just need to export raw data to Excel, there are a couple easy ways to do that. You don’t need to automate Excel, something the programmers posting in the forums seem to frequently do. That just makes things more complicated, and if you run the code in a server agent, Microsoft Office have to be installed on the server itself.
I read this, and immediately thought: “Aha. Excellent point!”.
I always have been in the habit of coding to the Excel objects, which does require a local Excel install, and does require Office on the servers. I freely admit that I got stuck in my habits from eons ago, and never updated my thinking.
He is right. My ways are old-fashioned, and his ways are better. I just wanted to call out his post, and thank him for knocking me back on-track in my own thinking.