Runtime error '9' ' subsscript out of range

Hi Experts

We are trying to migrate on BW 3.1C BEx Workbook with Excel Macro to BI 7.0 workbook.

Normally if we open the workbook in BEx analyzer 7.0 , it should be migrated. But here in our case , we are getting error message.

*Runtime error '9' ' subsscript out of range*

We are using SAP GUI 7.20 as the front end. Could please advise ?

Thanks in advance!