Thank you!

Here I thought I was being slick!

Oh well!

You make a good point. I was trying to create a stored procedure that could be used on multiple forms for multiple tables instead of creating a procedure for...

That's what I was afraid of. And, not knowing that, I have already migrated the packages and made 3 days work of coding changes. I supposed there is...

Thanks!

Lutz -- I will try what you suggested. The fn_CalcIsColor() is just a bunch of calculations so that would work.

Thanks. We're actually trying to avoide updating the spreadsheet upon opening. The goal is to just have the finished spreadsheets sitting out on a share.

We decided...

We were originally using Reporting Services but the export process from there wasn't going to produce the spreadsheet the way the customer wanted it. So, we decided to go...

That's an idea...and might work...

The excel file is formated with headers, font, column headers are rotated in some cases. Now, the template just sits there already looking the way...