CE10 Excel Macro

[dandcg]

I was wondering whether it was possible fron within CE10 to export data to a worksheet on a pre-defined Excel template and then trigger a macro within the worbook completly within the realms of CE10?

Can anybody shed any light on this?

Dan

 

[synapsevampire]

I don't think you can in that fashion, but you could export the data to a spreadsheet, and then open a spreadsheet from within custom ASP code which has an autostart macro in it that reads in the exported data and does whatever you need.

Check out this thread:

http://www.experts-exchange.com/Web/Web_Languages/ASP/Q_20537393.html

-k

 

[dandcg]

Cheers for that although the trouble is the macro would take a while to complete and I only want it to complete once, and then be distrubuted. Not each time the sheet is opened...