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

[ALDEBARAN]

Hello,

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

Thank you

[ChrisNZ · Accepted solution]

Your need is very much unclear. 

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

[ALDEBARAN]

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]

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.