Is programming in Excel better or worse than programming Sharepoint?
Anyhoo, I was trying to merge 5 single worksheet excel spreadsheets into a new spreadsheet, and then deleting the blank worksheet created when you create the new spreadsheet.
But when calling delete on it, I would get one of those fantastic COM errors you get when programming like it’s 1989. I tried many different things before realizing:
app.Visible = true;
would do the trick (I made it invisible because it is a server side process).