Thanks for another great blog post. To extend on your example, I put the files in the location of the SAS WORK library using this code:

%let myWorkLocation = %sysfunc(pathname(work));
ods tagsets.ExcelXP file="&myWorkLocation/sample.xml" style=htmlblue;

this allows it to run on any SAS server (Linux/Unix) and since the copy file task also supports macro variables, this works just great