Results 1 to 3 of 3

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

  1. 02-29-2012, 08:35 PM #1
    LalitPandey87
    LalitPandey87 is offline
    Senior Member LalitPandey87's Avatar
    Join Date
    Sep 2011
    Posts
    222
    Rep Power
    14

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

    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.
    Last edited by LalitPandey87; 03-01-2012 at 07:23 AM.
    Reply With Quote Reply With Quote
  2. 02-29-2012, 09:19 PM #2
    Admin
    Admin is offline
    Administrator Admin's Avatar
    Join Date
    Mar 2011
    Posts
    1,123
    Rep Power
    10
    Hi,

    Please have a look at these links:

    VBA to copy particular webpage content - MrExcel Message Board

    VBA copy and paste (Not web query) from open web page? - MrExcel Message Board

    VB Helper: HowTo: Display the text of a Web document without using Internet controls
    Cheers !

    Excel Range to BBCode Table
    Use Social Networking Tools If You Like the Answers !

    Message to Cross Posters

    @ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)
    Reply With Quote Reply With Quote
  3. 04-08-2012, 09:42 AM #3
    LalitPandey87
    LalitPandey87 is offline
    Senior Member LalitPandey87's Avatar
    Join Date
    Sep 2011
    Posts
    222
    Rep Power
    14
    Thanks admin :Cheers:
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Copy/Paste Excel Range/Chart into Powerpoint VBA
    By Admin in forum Excel and VBA Tips and Tricks
    Replies: 1
    Last Post: 03-13-2014, 02:59 PM
  2. VBA -- Copy/Paste across sheets
    By Rasm in forum Excel Help
    Replies: 4
    Last Post: 09-21-2012, 02:07 PM
  3. Copy selected data to other excel sheet
    By dhiraj.ch185 in forum Excel Help
    Replies: 2
    Last Post: 02-02-2012, 06:23 AM
  4. Copy Existing Sheet, Paste Values from existing workbook into new workbook
    By crcline in forum Excel Help
    Replies: 9
    Last Post: 09-09-2011, 02:30 AM
  5. Trapping Copy To Range Before Copy/Cut Paste
    By Rasm in forum Excel Help
    Replies: 4
    Last Post: 04-07-2011, 07:48 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules