+ Reply to Thread
Results 1 to 2 of 2

How to save HTML source code from VBA?

  1. #1
    Forum Contributor
    Join Date
    08-12-2006
    Posts
    106

    How to save HTML source code from VBA?

    Hi,

    I would need to get HTML source code from any given page. I know how to open a HTML page from Excel and I can do it with VBA, but how to get for example this page's source code?

    I would start with making a sub that takes a string (the address) as an input parameter and finish with saving the source code of that address as an text file like c:\code.txt

    So something like

    Dim webaddress as string

    Sub GetSourceCode(webaddress)
    'then some code to save the source code
    End Sub

  2. #2
    Forum Contributor
    Join Date
    08-12-2006
    Posts
    106
    So this is done by using sendkeys and Firefox. I'd like to get this same thing to work without sendkeys, so I think it virtually means using Internet Explorer object model.

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Tweaking VBA Code for HTML Table Cell Reading
    By ShannonLarson in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-07-2009, 05:08 PM
  2. Parse HTML code, create a table
    By bg18461 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-17-2008, 04:46 AM
  3. Looking for add-in to edit HTML code in select worksheet cells
    By Mr. Chip in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-09-2007, 03:58 PM
  4. VBA code that will save all sheets in workbook to seperate workbooks
    By Zyphon in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-04-2007, 02:44 AM
  5. Save code in VB
    By Brento in forum Excel General
    Replies: 2
    Last Post: 09-26-2006, 05:52 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1