Your SAS programs, embedded in web apps and elsewhere

Excel Macro through excelXP or any tagesets

Reply
N/A
Posts: 0

Excel Macro through excelXP or any tagesets

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
SAS Super FREQ
Posts: 8,868

Re: Excel Macro through excelXP or any tagesets

Posted in reply to deleted_user
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
N/A
Posts: 0

Re: Excel Macro through excelXP or any tagesets

Posted in reply to Cynthia_sas
Thanks Cynthia. Will try that
Ask a Question
Discussion stats
  • 2 replies
  • 196 views
  • 0 likes
  • 2 in conversation