I have an excel spreadsheet template that has to be filled in every week with SAS data. Way back when, I used DDE to do this and place data in pre-defined cells in the excel template. Since DDE is gone to pasture, I'd like to be able to do this with ODS excel if that is possible. Anyone have an idea of how I would start.    I use ODS Excel all the time to create fresh excel tables but never for a pre-defined excel spreadsheet template.   Help. ... View more