BACKGROUND
We have an excel file having 4 sheets. This workbook has a few macros (VBA procedures/functions). These sheets gets filled up dynamatically when it is accessed by user over web with there own parameter values.
HOW DOES IT WORK?
User passes parameter values to an ASP file(like client_id,year etc.) which gets passed to the excel macro and this macro then call another macros and fills all the sheets with data. After that user gets a dialog to run this excel from the server or he can download the resultant excel on his machine.
PROBLEM
We don't want to have macros embedded to the sheet which gets download. For this what we do is, we copy/move the entire sheet(after it gets filled up with data) to another sheet(in other excel file) and this file gets download for the user. Now what happen is becoz of this move/copy we lost some background color of cell. We have RGB(214, 227, 247) in our sheet but after move it becomes some other color. This happen even if you do it in excel itself. Right lick on the Sheet tab below and say "Move or Copy..." and select "(new book)" from the combo "To Book" and click OK....
We have an excel file having 4 sheets. This workbook has a few macros (VBA procedures/functions). These sheets gets filled up dynamatically when it is accessed by user over web with there own parameter values.
HOW DOES IT WORK?
User passes parameter values to an ASP file(like client_id,year etc.) which gets passed to the excel macro and this macro then call another macros and fills all the sheets with data. After that user gets a dialog to run this excel from the server or he can download the resultant excel on his machine.
PROBLEM
We don't want to have macros embedded to the sheet which gets download. For this what we do is, we copy/move the entire sheet(after it gets filled up with data) to another sheet(in other excel file) and this file gets download for the user. Now what happen is becoz of this move/copy we lost some background color of cell. We have RGB(214, 227, 247) in our sheet but after move it becomes some other color. This happen even if you do it in excel itself. Right lick on the Sheet tab below and say "Move or Copy..." and select "(new book)" from the combo "To Book" and click OK....