How to extract and copy a specific sheet in an Excel file to another folder with SAS?

[BigPete]

Although this thread (https://communities.sas.com/t5/SAS-Programming/Copy-Excel-file-from-one-folder-to-another/m-p/418901...) was helpful about how to copy an Excel file from one folder to another with SAS, is there a way to copy a specific sheet in an Excel file with multiple sheets to another folder with SAS? I'm using SAS 9.4.

[PaigeMiller]

You could read the sheet into a SAS data set and then use SAS to write a brand new spreadsheet in another folder. CAUTION: not all features in Excel can be copied this way.

[BigPete]

@PaigeMiller but any idea how to preserve original formats?

Any idea how to keep this appearance into the target copy?

Don't want the copy to look like this:

And any idea if there's a way in SAS to extract a specific sheet in a multi-sheet Excel file and copy each into separate Excel files?

[PaigeMiller]

If you really have to preserve the formats, then look at Visual Basic. I don't think that SAS is the right tool for this.