Can I create excel vba macro through excelXp or any tagset while creating excel report? I tried many cool options with excelXp tagsets to create excel file with all these autofilter and other options. I also figured out to launch the existing macro based on personal.xls file. But couldn't find out how to add a piece of vba macro to the excel generated through ODS. Has anyone tried this?
Most of the VBA macro examples that I've seen use HTML output as the vehicle and not TAGSETS.EXCELXP (see Chevell Parker's paper). I'm not exactly sure how you would put this all together. Several of these papers have extensive reference sections at the end, which may help point you in a direction. Again, Tech Support is probably your best bet for help.