Microsoft Internet Explorer (version 5.0 or higher) includes a popular way for you to create a Web query in Microsoft Excel (version 2000 or higher). Following steps will show you, how to add the "Export to Microsoft Excel" option to the right-click menu in Internet Explorer:
Open Internet Explorer and browse a Web page containing tabular data. Right click on the table and choose "Export to Microsoft Excel". Select one or more tables by clicking the arrows adjacent to each table.
- Click on Start Button
- Click Run
- Type regedit and press Enter
- Then Browse following:
HKEY_CURRENT_USER \ Software \ Microsoft \ Internet Explorer \ MenuExt- Right click MenuExt =>select New
- Select Key and name it "Export to Microsoft Excel" without the quotes
- With the new subkey "Export to Microsoft Excel" highlighted, double click (default) in the right hand window pane, and set its "Value data" as follows:
For Excel 2003 (OFFICE11)
res://C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE/3000For Excel 2007 (OFFICE12)
res://C:\Program Files\Microsoft Office\OFFICE12\EXCEL.EXE/3000- Exit the Registry Editor.
Bookmarks