Sheet Name in Excel After Data Transfer

We've migrated almost all our old .dtf files to the new .dtfx format after upgrading most of our PCs from IBM i Client Access for Windows to Access Client Solutions. Transfers to and from the IBM i seem to have gone well, however we recently noticed that transferring from the IBM to an Excel file automatically renames the Sheet in the file to part of the library.filename:

For example: “A9PRDDTA.INVONHAND2(INVO>Sheet1”

Previously, the Sheet name would simply match the Excel file name. The recent update in 1.1.8.1 (currently on 1.1.8.2) allows the use of Sheet%2$s in the AcsConfig.properties file, however that only names the sheet to Sheet1.

If there was a way to modify the config properties file to allow the data transfer to keep the sheet named the same as the Excel file name as it had done previously, that would be very helpful to our Access Client users that have set macros to target sheet names.

We've migrated almost all our old .dtf files to the new .dtfx format after upgrading most of our PCs from IBM i Client Access for Windows to Access Client Solutions. Transfers to and from the IBM i seem to have gone well, however we recently noticed that transferring from the IBM to an Excel file automatically renames the Sheet in the file to part of the library.filename:

For example: “A9PRDDTA.INVONHAND2(INVO>Sheet1”

Previously, the Sheet name would simply match the Excel file name. The recent update in 1.1.8.1 (currently on 1.1.8.2) allows the use of Sheet%2$s in the AcsConfig.properties file, however that only names the sheet to Sheet1.

If there was a way to modify the config properties file to allow the data transfer to keep the sheet named the same as the Excel file name as it had done previously, that would be very helpful to our Access Client users that have set macros to target sheet names for a while now.