Copy webpage and paste it as HTML into an excel sheet using vba

[LalitPandey87]

Hi All,


Thanks for all your valuable solutions for all my last posts.

Is there any procedure which copy a web page and paste special it as HTML format in an excel sheet using vba.

I google for it but didn't find any solution which works.

Thanks in advance.

[Admin]

Hi,

Please have a look at these links:

VBA to copy particular webpage content - MrExcel Message Board (http://www.mrexcel.com/forum/showthread.php?t=603712)

VBA copy and paste (Not web query) from open web page? - MrExcel Message Board (http://www.mrexcel.com/forum/showthread.php?t=534042)

VB Helper: HowTo: Display the text of a Web document without using Internet controls (http://www.vb-helper.com/howto_read_url_without_inet.html)

[LalitPandey87]

Thanks admin :Cheers: