Hi Experts,
I'm maintaining a very large QTP test solution (close to 100 reusable actions/tests) that was developed in the days of Excel 97. These tests/actions use very long names greater than 31 characters and relies extensively on Global and Local datasheets (dtLocalSheet) for its data. I have one master spreadsheet in Excel 97 that has all the data (both global and local) required for the test suite. I now want to migrate this spreadsheet from the outdated Excel 97 to Excel 2010. There is one major problem - Excel 97 supported sheet names with greater than 31 chars while Excel 2010 supports a max of 31 chars for its sheet names. So all (dtLocalSheet) references in my test suite fails for tests with names greater than 31 chars (as saving the master spreadsheet in Excel 2010 truncates all long sheet names down to 31 chars).
What might be the best way to migrate the master spreadsheet to Excel 2010 with minimal changes to the code itself?
I'm maintaining a very large QTP test solution (close to 100 reusable actions/tests) that was developed in the days of Excel 97. These tests/actions use very long names greater than 31 characters and relies extensively on Global and Local datasheets (dtLocalSheet) for its data. I have one master spreadsheet in Excel 97 that has all the data (both global and local) required for the test suite. I now want to migrate this spreadsheet from the outdated Excel 97 to Excel 2010. There is one major problem - Excel 97 supported sheet names with greater than 31 chars while Excel 2010 supports a max of 31 chars for its sheet names. So all (dtLocalSheet) references in my test suite fails for tests with names greater than 31 chars (as saving the master spreadsheet in Excel 2010 truncates all long sheet names down to 31 chars).
What might be the best way to migrate the master spreadsheet to Excel 2010 with minimal changes to the code itself?