Mrrrr's Forum (VIEW ONLY)
Un forum care ofera solutii pentru unele probleme legate in general de PC. Pe langa solutii, aici puteti gasi si alte lucruri interesante // A forum that offers solutions to some PC related issues. Besides these, here you can find more interesting stuff.
Lista Forumurilor Pe Tematici
Mrrrr's Forum (VIEW ONLY) | Reguli | Inregistrare | Login

POZE MRRRR'S FORUM (VIEW ONLY)

Nu sunteti logat.
Nou pe simpatie:
morena28 din Bistrita Nasaud
Femeie
24 ani
Bistrita Nasaud
cauta Barbat
24 - 49 ani
Mrrrr's Forum (VIEW ONLY) / Tutoriale si Ghiduri Utile // Tutorials and useful guides / [VBS] Previous Week's News on European Commission's Press Corner Moderat de TRaP, TonyTzu
Autor
Mesaj Pagini: 1
TRaP
Moderator

Inregistrat: acum 6 ani
Postari: 739
With the following vbs script (saved as .vbs file) you open a webpage with the Daily News on the Press Corner website of the EC:

The interval is from yesterday to 1 week before yesterday.

If today is 22.03.2023, that means it will filter Daily News articles from 14.03.2023 to 21.03.2023.

IMPORTANT: THIS WORKS FOR ROMANIA'S REGIONAL SETTINGS SINCE THE NOW() FUNCTION WILL RETURN DAY NAMES IN ROMANIAN. To make it work in English you must change the wkdy case since it will probably state full day names like Monday, Tuesday etc. that must be shortened in Mon, Tue etc. Everything else should be the same.



Dim shell
Dim yr, yrStop
Dim mth, mth_2, mthStop
Dim dy, dyStop
Dim wkdy, wkdyStop

Dim dtStart
Dim dtStop

Dim lnk

yr = Year(Now())
mth = Month(Now())
mth_2 = Month(Now())
dy = Day(Now())
wkdy = WeekDayName(WeekDay(Now()))

Select Case mth_2

Case 1
    mth_2 = "January"

Case 2
    mth_2 = "February"

Case 3
    mth_2 = "March"

Case 4
    mth_2 = "April"

Case 5
    mth_2 = "May"

Case 6
    mth_2 = "June"

Case 7
    mth_2 = "July"

Case 8
    mth_2 = "August"

Case 9
    mth_2 = "September"

Case 10
    mth_2 = "October"

Case 11
    mth_2 = "November"

Case 12
    mth_2 = "December"

End Select

dtStart_2 = dy & "%20" & mth_2 & "%20" & yr

Select Case mth

Case 1
    mth = "Jan"

Case 2
    mth = "Feb"

Case 3
    mth = "Mar"

Case 4
    mth = "Apr"

Case 5
    mth = "May"

Case 6
    mth = "Jun"

Case 7
    mth = "Jul"

Case 8
    mth = "Aug"

Case 9
    mth = "Sep"

Case 10
    mth = "Oct"

Case 11
    mth = "Nov"

Case 12
    mth = "Dec"

End Select

Select Case wkdy

Case "luni"
    wkdy = "Mon"

Case "mar" & ChrW(539) & "i"
    wkdy = "Tue"

Case "miercuri"
    wkdy = "Wed"

Case "joi"
    wkdy = "Thu"

Case "vineri"
    wkdy = "Fri"

Case "s" & ChrW(226) & "mb" & ChrW(259) & "t" & ChrW(259) ' "sāmbătă"
    wkdy = "Sat"

Case "duminic" & ChrW(259)
    wkdy = "Sun"

End Select

dtStart = wkdy & "%20" & mth & "%20" & dy & "%20" & yr


' ---------- stop date -----------

yrStop = Year(Now())
mthStop = Month(Now())
dyStop = Day(Now())
wkdyStop = WeekDayName(WeekDay(Now()))

dtStop = DateSerial(yrStop, mthStop, dyStop) - 7

yrStop = Year(dtStop)
mthStop = Month(dtStop)
dyStop = Day(dtStop)
wkdyStop = WeekDayName(WeekDay(dtStop))

Select Case mthStop

Case 1
    mthStop = "Jan"

Case 2
    mthStop = "Feb"

Case 3
    mthStop = "Mar"

Case 4
    mthStop = "Apr"

Case 5
    mthStop = "May"

Case 6
    mthStop = "Jun"

Case 7
    mthStop = "Jul"

Case 8
    mthStop = "Aug"

Case 9
    mthStop = "Sep"

Case 10
    mthStop = "Oct"

Case 11
    mthStop = "Nov"

Case 12
    mthStop = "Dec"

End Select


Select Case wkdyStop

Case "luni"
    wkdyStop = "Mon"

Case "mar" & ChrW(539) & "i"
    wkdyStop = "Tue"

Case "miercuri"
    wkdyStop = "Wed"

Case "joi"
    wkdyStop = "Thu"

Case "vineri"
    wkdyStop = "Fri"

Case "s" & ChrW(226) & "mb" & ChrW(259) & "t" & ChrW(259) ' "sāmbătă"
    wkdyStop = "Sat"

Case "duminic" & ChrW(259)
    wkdyStop = "Sun"

End Select

dtStop = wkdyStop & "%20" & mthStop & "%20" & dyStop & "%20" & yrStop

lnk =     "https://ec.europa.eu/commission/presscorner/advancedsearch/en?keywords=&dotyp=3&parea=&pareaType=&datepickerbefore=&datebefore=" & _
                    dtStart & _
                "&commissioner=&datepickerafter=" & _
                    dtStart_2 & _
                "&dateafter=" & _
                    dtStop & _
                ""

Set shell = CreateObject("WScript.Shell")
    shell.Run lnk


pus acum 1 an
   
Pagini: 1  

Mergi la