Quote Originally Posted by xld
The Environ variables are staic, but surely it does not matter. The computer name will not change probably ever, certainly not during a session will it? As such, I don't see any need for an approach other than what you have.
Thanks Bob, appreciate your insights as always.

I was just keen to see an alternative approach as well, for learning purposes at least via Kenneth's API suggestion.

Though the current approach on limited testing seems to work well.

Thanks to contributions from Experts such as yourself, I am slowly developing a front end for running SAS through Excel.

If it works as planned, it will be a really nice way to automate stuff for the form going forward, with limited maintenance (hopefully).

I'll slowly start putting up the many queries I have for it to get your thoughts/ feedback on it.

sincere regards,