I'm attempting to connect to an excel file using an ADO recordset. There is a column in this that I need the sum of for a report. I'm familiar with ADO connections, so I assumed this would be the ...

When you think VBA code is your only hope, try combing built-it conditional formatting tools. You might just find an easier solution than writing code.

If you have users who prefer to push Excel data into Outlook instead of importing it from inside Outlook, try this VBA event procedure.