Reeza, Thanks! By changing the way EXCEL opens, it seems to work just fine now. It's funny, I've had this program for years and it always baffled me why one time Excel would open with everything running fine and other times it would open Excel but not run the macro. I always got the same error. ERROR: File is in use, EXCEL|SYSTEM. I would just close SAS and EXCEL, then reopen SAS and run it again. It would work the second time. This seems to have fixed the problem. This program has to run next week also, so I'll post if it was successful at the end of the week. Thanks much. Nancy
... View more