topic Excel Macro through excelXP or any tagesets in Developers

Excel Macro through excelXP or any tagesets

deleted_user — Mon, 06 Aug 2007 01:31:30 GMT

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

Re: Excel Macro through excelXP or any tagesets

Cynthia_sas — Mon, 06 Aug 2007 02:39:23 GMT

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

Re: Excel Macro through excelXP or any tagesets

deleted_user — Mon, 06 Aug 2007 22:51:12 GMT

Thanks Cynthia. Will try that