Thanks RW9. I appreciate your forthrightness. There are a total of about 100 tables, and they are use output to a source file with "sheet" built tabs, that are then linked/copied to a destination file. UGH. So on the next go around of these 100 tables for the next year, I plan to use proc report to generate all of them...I understand and have used it and it provides a better formatting mechanism and such. Anyway, we are on deadline, and me generating this code will take more time than I am allowed thus the fidgeting with trying to work with what I have now. In addition,as might be evident, this code is much longer than what I attached, and though I understand what I am producing, I would not be able to write this code myself and there are 5 of these tables. I will investigate "ods tagsets.excelxp ." Thanks so much!
... View more