Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Problem with NumberFormat Local property - Business Explorer

Hi BW Experts.

I have problem with using SAP Business Explorer v7.0.

Step by step:

1. Open BEX Analyzer

2. Open query and log on into the system

3. Select report

4. fulfill variable table and execute

5. it cause following error

´Run-time error 10004´

Unable to set the NumberformatLocal property of the Range class

After debugging:

lSheet.Range(ltAddress(lCount)).NumberFormatLocal = ltVBFormat(lCount)


I have no problem to execute the report in SAP BEX v3.5.

My version:

SAP GUI 7.10

"BI AddOn Patch for GUI 7.10" patch level 700 for SAP NetWeaver 7.1 on my workstation was applied.

MS Excel version 2003 and then 2007 for testing

Points will be assigned.

Thank you.


Former Member
Not what you were looking for? View more on this topic or Ask a question