topic Re: SAS EXCEL ADD-IN 8.2 - refresh SAS CODE in VBA in SAS Programming

SAS EXCEL ADD-IN 8.2 - refresh SAS CODE in VBA

ALDEBARAN — Fri, 18 Feb 2022 09:38:55 GMT

Hello,

I search a way to refresh SAS Program in VBA through SAS OFFICE ADD-IN 8.2?

Thank you

ChrisNZ — Wed, 23 Feb 2022 06:16:48 GMT

Your need is very much unclear.

Please explain more: what do you have, what do you want?

ALDEBARAN — Wed, 23 Feb 2022 08:16:06 GMT

hello,

1 - In EXCEL SAS ADD-IN 8.2 we can write and execute SAS Code manually. it's ok .

2 - I can execute all EXCEL SAS ADD-IN 8.2 orders in VBA except SAS code executing.

3 - I've got to execute this sas code in the same sas session opened by the SAS ADD-IN 8.2.

4 - I search, if possible, to automate the sas code execution in VBA with SASExcelAddIn objects...

Thanks a lot

ChrisNZ — Wed, 23 Feb 2022 10:03:33 GMT

I reckon your post title would be a lot clearer as "Run SAS code in Excel add-in via VBA"

It looks like VBA's access to add-ins is rather limited, see https://docs.microsoft.com/en-us/office/vba/api/excel.addins

but maybe someone else has dug deeper than I have.