hi SAS I have the same problem. The reason that we go through the long route from SAS -> Excel -> PDF, because we can have better graphs in excel after data dumped into excel template, and we need to have pdf files by converting hundreds of excel work sheets into pdf and assembled them together.  We need to know how to trigger VBA macros to do these two things: Save excel to pdf and attached them together. This can be done by DDE before in local setting. But we cannot trigger VBA in SAS studio. How can we save hundreds of excel worksheet into one PDF file?   Thanks Maggie ... View more