Export HTML page in Webbrowser control to Microsoft Excel
I have created a report using HTML and that is view over webbrowser control. Now I want export the report to Excel using excel's Import Wizard -> New Web Query. In that I have a full control over my HTML Report like whether I need in Rich Text Format, Web Query Redirections etc. Presently I'm able to do this by Right Click the HTML Report and in that if I click "Export to Excel" then I get these things. But I want to get it thorough Command Button. When I click Command Button I should be able to get the New Web Query wizard of Excel with the current HTML page. any one help ?