PDA

View Full Version : Importing .html file into Sheet in Excel in VBA



nikon3d
08-29-2011, 05:35 PM
Hi All,

When you right-click an html document and open as "Excel", Excel will open up and retain the html appearance in the sheet.

I am trying to write VBA code to import an HTML file (.html) into the worksheet while maintaining the HTML look. (I do not want the html code to appear in the sheet).

How would I achieve this?

Thanks

hcadar1
09-02-2011, 09:01 AM
Can you explain what you mean when you say "(I do not want the html code to appear in the sheet)? When you import the file, are you looking to remove all of the hyperlinks and form objects on the html page showing only the text (with formatting) and graphics?
Are the files to be imported already saved locally? Or do you want to have the code go to a specific site and pull the page?