Excel Macro through excelXP or any tagesets

[deleted_user]

Hi folks
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?

cheers
Suren

[Cynthia_sas]

Hi,
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.

cynthia
http://www.lexjansen.com/pharmasug/2003/sasinstitute/sas129.pdf
http://www2.sas.com/proceedings/sugi29/222-29.pdf
http://www.lexjansen.com/phuse/2005/as/as11.pdf
http://www2.sas.com/proceedings/sugi30/157-30.pdf

[deleted_user]

Thanks Cynthia. Will try that