Update SAS data sets in workbook using VBA

[nellaneb]

Hi everyone,

I am hoping there is a solution to the problem I am having. I am trying to use VBA code to refresh all SAS data sets in a given workbook and what I have written works, however it does not limit itself to the SAS links in the workbook the code is in. If there are any other workbooks open with SAS link in them it will also refresh them and that exposes me to some big risks and I cannot do that. Here is what I have written:

Please Login or Register  to view this content.

Does anyone know a way to limit the SAS data sets this code will refresh to only the ones in this specific workbook and ignore all other data sets if another workbook is open and contains them? Any help will be greatly appreciated. Thanks!

[nellaneb]

Or maybe there isn't a solution and this is the way it works with SAS and VBA...