cancel
Showing results for 
Search instead for 
Did you mean: 

Runtime error '9' ' subsscript out of range

Former Member
0 Kudos

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!

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

HI All,

Thanks a lot for your valuble input. However, It did not help. We applied BI addon- patch 700 and 3.5 addon-patch 10. We are still facing the same issue.

Even before migration, when we tried to execute the workbook in 3.5 we are facing runtime error "1004"

This perticular work book has lot of hidden sheets which are password Protected. It containg both Sheet protection and Structure protection.

Thanks...

arvind_doomra
Active Contributor
0 Kudos

Dear Amar,

Please note that this is known issue with patch 4 of BW 3.5 Addon of GUI 720.

Please apply the latest patch from service market place. This will resolve your issue:

Please also refer to Note  1557545.

Please download from below path:

-> http://service.sap.com/patches

-> Browse our Download Catalog

-> SAP Frontend Components

-> BI ADDON FOR SAP GUI

-> BW 3.5 ADDON FOR SAP GUI 7.20

-> BI 3.5 ADDON FOR SAP GUI 7.20

-> Win32

-> Apply the latest.

Regards,

Arvind

Former Member
0 Kudos

Hi Amar,

Please check this thread ::

http://scn.sap.com/thread/2009961

Best Regards,

Arpit

michael_devine
Employee
Employee
0 Kudos

Hi,

This is a known issue and is solved with the patch mentioned in Note 1557545 '3x Analyzer: RRMX Support for SAP Router Strings'.

Current BI ADDON FOR SAP GUI 720
http://wiki.sdn.sap.com/wiki/x/wQ8MDg

Complete Installation SAP GUI 720 + Frontend
http://wiki.sdn.sap.com/wiki/x/CIENDw

Regards,

Michael