Excel to BW

Prerequisite excel settings

• Excel should be Macro enabled. ( Save excel with extension .xlsm)
• Make sure ‘Developer’ option is enabled.
• If not, Options -> Popular à ‘show developer tab in the Ribbon’.
• Create a table (Excel -> Insert -> Table ) in excel and then enter data inside the table ( might work directly inserting data in the sheet, I am not sure)
• Alt+F11 would open the VB screen.
• VBA Settings
• Clicking on ‘Developer’ tab in excel. It has VBA editor icon.
• Open VBA and check following in Tools à References
• ‘Microsoft XML.v6.0’ checked.
• ‘Micorsoft DAO 3.6 Object Library’ is checked.

Points to remember