Hi:   When you say you are using "ods tagsets", that implies you are using ODS TAGSETS.EXCELXP??  Since you are running SAS 9.4, is ODS EXCEL an option? I do not believe a STYLE template will help you here. For example, in a STYLE template, all the column headers would be defined to be the SAME color, while in your screen shot, you show 4 of the column headers in blue and 3 in gray for the background. A STYLE template doesn't care about your data and your column headers, it would normally color the background of ALL the headers the same.     If you want to alter the style of what you create to match what you are pasting into, then using style overrides in PROC REPORT, PROC PRINT or PROC TABULATE would be a better option. Cynthia ... View more

I noticed you're using remote submit. That means the code goes to a server and does't have access to your C drive or Excel and you very likely cannot do remote submission to use DDE. That would require having Excel and your file on the server.   @stc200896 wrote: No, I didn't realize until after I posted that excel wasn't opening.  I get an error saying excel.exe not found.  I've reached out to my IT team but haven't heard back yet.  I've verified it's in that location.   NOTE: Remote submit to MIRAGE commencing. REMOTE(MIRAGE): /bin/ksh: C:\Program Files (x86)\Microsoft Office\Office14\EXCEL.EXE: not found 2412 x '"C:\Program Files (x86)\Microsoft Office\Office14\EXCEL.EXE"'; ; 2413 2414 data _null_; 2415 x=sleep(30); 2416 run; NOTE: DATA statement used (Total process time): real time 0.03 seconds cpu time 0.00 seconds 2417 2418 data _null_; 2419 file sas2x1; 2420 put '[Open("C:\My Documents\TEMPLATE.xlsb")]'; 2421 run; NOTE: 1 record was written to the file SAS2X1. The minimum record length was 68. The maximum record length was 68. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 2422 2423 filename sas2x1 dde 'excel|WHSE_10!r7c1:r150c57' lrecl=1024; ERROR: Invalid device type. ERROR: Error in the FILENAME statement. 2424 2425 data _null_; 2426 set Staci.whse_10; 2427 file sas2x1; 2428 put var1 '09'x var2 '09'x var3 '09'x var4 '09'x var5 2429 run; NOTE: 15042 records were written to the file SAS2X1. The minimum record length was 1. The maximum record length was 256. NOTE: There were 8420 observations read from the data set STACI.WHSE_10. NOTE: DATA statement used (Total process time): real time 0.13 seconds cpu time 0.13 seconds 2430 2431 2432 2433 data _null_; 2434 file sas2x1; 2435 put '[error(false)]'; 2436 cmnd = '[save.as("C:\My Documents\Testing_DDE.xlsb")]'; 2437 put cmnd; 2438 put '[file.close(true)]'; 2439 put '[quit()]'; 2440 run; NOTE: 4 records were written to the file SAS2X1. The minimum record length was 8. The maximum record length was 54. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: Remote submit to MIRAGE complete.       ... View more

I can't tell you how many times I tried that and it still wouldn't go away!  But of course, I try it now and it's gone!  Thanks so much.  I feel so silly but you have just made my day.  Thanks again! ... View more

I tried both solutions and they both worked!  Thank you so much! ... View more