VBA and SAS IOM - applying formats
Sample code (and tips) for applying SAS Formats to data before pulling into excel:
Dim obConnection AsImprove performance of DI Studio client
You can speed up the performance of your DI Studio client by increasing memory via the JavaArgs_1 variable in the distudio.ini file. A suggested approach is to increase from -Xmx512m to -Xmx1024m.
Allow XCMD on the workspace server
Paul Homes has an excellent explanation of this.. The below may be helpful as a simple quick reference guide.