Look at DesignPatterns, specifically
Decorator and
Strategy>Hi everybody,
>
>I have a custom function (thanks to Cetin & Borislav) that produces an Excel from DBF and applies some additional formatting. This function is called from several modules and it uses an array of field names.
>
>Now I have a need to add a certain color to some cells. For instance, we're sending the Excel file to third party and we want it to receive it with certain fields filled in. I want to add empty columns myself and I want them in the different color, so the third party would know, where new fields start.
>
>There could be several approaches:
>
>1. Leave the original function in tact, create a new function to apply additional formatting and call both functions.
>
>2. Have some optional parameters in the original function.
>
>I think, the second approach is better. I'm thinking, what kind of parameters would I need to add to the routine to make this generic enough?
>
>What do you think?
>
>Thanks in advance.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer