topic VBA in SAS Programming

VBA

Ronein — Wed, 04 Dec 2019 09:14:17 GMT

Hello

Is it possible to add VBA codes into sas when I export table from sas into excel?

Re: VBA

PeterClemmensen — Wed, 04 Dec 2019 09:41:06 GMT

I'm not sure but I don't think so.

Re: VBA

Patrick — Wed, 04 Dec 2019 09:52:58 GMT

If you want to end up with an Excel workbook that contains both your data from a SAS table and VBA code then easiest would be to already have this Excel workbook created with all the VBA code in it and just have SAS add a data sheet to it.

I believe if you really also would want to generate the VBA code in SAS and fully create the Excel then you would need to write all the code which fully generates the XML for the Excel. I've done that once and can't recommend to try it - it's complicated, fully manually coded and very messy.

Re: VBA

ChrisNZ — Wed, 04 Dec 2019 11:07:07 GMT

>you would need to write all the code which fully generates the XML for the Excel. I've done that once and can't recommend to try it - it's complicated, fully manually coded and very messy.

Maybe a middle-ground-solution would be to have the XML ready and just update the XLSX zip file ?

Re: VBA

Patrick — Wed, 04 Dec 2019 11:30:08 GMT

@ChrisNZ

That's what I've basically done once - and hopefully never will have to do again. Problem is that the MS Office Excel XML is just "ugly".