ODS-to-Excel

[deleted_user]

Can one use the ExcelXP tag set to write SAS data sets to named ranges in an Excel spreadsheet? If so, may I ask that an example be provided?

[deleted_user]

I believe a named range is referenced in exactly the same way that a sheet name is referenced.

Where you specify the sheet name, replace this with the range name, and don't forget the string indicator (the $ sign after the name).