Excel/VB Macro

Recently we were working on a report which actually throws an excel file as an output.

Excel include huge amount of data and then a lot of calculations to be performed on the data, to create various graphs and various reports with in the same excel in different sheets.

Initially we were doing all this on server using office com component. So time required to create the file was quite a lot and performace was very poor.

Then we realized that we can just populate the data in excel on server. that will expedite the proccess of file creating on server and response time should increase (this is obvious )

And for rest of the calculation, we simply went inside the excel file, wrote a VB macro, that will do all the calculation on the data available inside the excel file on click of a button (we did that on button click not while file is opening because we do not want user to assume that there is a problem in the file, in case calculations take longer time).

That way, we saved the network traffic and increase response time.

Popularity: 1% [?]