I gang

using vbscript and vba to combine web pages in excel

I have a list of ~100 links, the work to be done is to use vbs and vba:

1) check if the link is valid, links are in attached txt file

note that user can change the the [url removed, login to view] file in the future.

build a worksheet ("links") in an excel spreadsheet file, for each link, flag its validity with a valid/invalid sign in a separate column ("validity" column) next to the "link" column

2) download those links, save the webpage in a html or txt files in local drive. For link1, the file name should be link1-new.html. Meanwhile save previous downloaded version (the previous [url removed, login to view]) as [url removed, login to view], yyyymmdd being today's date

eg, the link [url removed, login to view] should be saved as link1-new, old one as link1-20080909

3) compare the [url removed, login to view] with [url removed, login to view], if same, mark a status column ("download status" column) with "same-yyyymmdd" in worksheet ("links")

If not the same or [url removed, login to view] did not exist (ie, it's a new link), then copy the webpage to the excel spreadsheet(sheet name "all-pages"), and put the modified page below the existing rows (ie, the "all-pages" may already have many rows from other links and previous downloads).

The first column of the "all-pages" should be link address

The 2nd column of the "all-pages" should be today's date

The 3rd column of the "all-pages" should be "same/new", explained below

The 4th- columns are the downloaded webpage

4) for each new row added to "all-pages" sheet (ie, these are webpages that has changed), compare with old rows from the same link in the "all-pages" sheet. Mark each row that's new with "same" in the 3rd column of the "all-pages", otherwise, mark it "new".

4. the information we need is the paper title and link and authors, note that these pages can have very different formats

5. we need vbs and vba source code, not an application

thanks.

Færdigheder: Excel, Visual Basic

Se mere: excel vba combine files, combine web pages, combine spreadsheet vbscript, click link using vba, check invalid link vbscript, excel invalid sign, combine webpages, vbscript click web link, excel vba validate links, vba copy web excel, using vbscript excel, vbscript check worksheet exists, vbscript merge excel files, vbscript excel merge, vbscript combine, vba link excel webpages, vba excel web vbs, excel vba vbscript, we excel, web page spreadsheet, web pages html code, web mark, vba work, vba with, spreadsheet web page

Om arbejdsgiveren:
( 6 bedømmelser ) New York, United States

Projekt-ID: #317063