PDA

View Full Version : Macro on Server



ardsouza
09-04-2009, 12:51 AM
In our current approach, we fire an ActiveX control on the browser that downloads a CSV from the server and formats the data based on formatting parameters (which is also present in the CSV). The final result is an XLS file that has the formatted data and a Pivot table on a separate sheet of the MS-Excel workbook. All this code is written in VBA macros which is then made part of the ActiveX control.

The problem with this approach is the lack of support for ActiveX in non-IE browsers. In order to support Mozilla, we are considering several options, including

1. Rewriting the whole thing in NPAPI technology, but then we need to maintain 2 sets of code parallelly.
2. Convert the CSV to the desired formatted XLS on the server itself (instead of the client side) and then download the file just as any other file download through the web browser.

For option#2, what options do we have to easily port the logic in the existing VBA macro code onto the server side, since VBA is Windows-based?

Any help would be greatly appreciated.

Thanks,

Allen