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:
Sabina
 | Femeie
22 ani
Bucuresti
cauta Barbat
22 - 60 ani |
|
|
TRaP
Moderator
Inregistrat: acum 6 ani
Postari: 739
|
|
I created the following formula to address searching for certain types of legislation on the EU site EURLEX.
Now, you can add this to a formula in Excel, or use it in a VBS or HTML code, it's your choice.
Version 1 - you have a checklist from which you pick 1 or 2 types of legislation documents (eg. Directive AND Regulation, not more than 2)
"https://eur-lex.europa.eu/search.html?DTA=" & _
YEAR & _
"&DTC=false&SUBDOM_INIT=ALL_ALL&DB_TYPE_OF_ACT=&DTS_SUBDOM=ALL_ALL&typeOfActStatus=OTHER&DTS_DOM=ALL&orFM_CODEDGroup=FM_CODED=" & _
DOCUMENT_TYPE_SHORT_NAME & _
",FM_CODED=" & _
2ND_DOCUMENT_TYPE_IF_ANY & _
"&lang=en&type=advanced&DTN=" & _
ZEROES & _
NUMBER
YEAR - the year of the document you are looking for, whether it is located in a cell in Excel, or a text field, a checkbox etc.
DOCUMENT_TYPE_SHORT_NAME - if you go to the EURLEX site, under Advanced Search, under Document reference, you can find a list of checkboxes, click Other, then you will have the type of legislative act / document, and between parenthesis the designated short name
2ND_DOCUMENT_TYPE_IF_ANY - in case you have a checklist and can pick 2 options - for example you want Communications from the Commission, you should use "NOTICE" - first and "COMMUNIC" - second
ZEROES - depending on the length of the document number (eg. 1 or 34 or 179 or 2139), you must add zeroes in from of the number so it results in a 4 digit number (eg. 0001, 0034, 0179 or 2139)
NUMBER - the number of the document you are looking for
Version 2 - you only pick a SINGLE TYPE OF DOCUMENT, but have a WORKAROUND FOR MULTIPLE TYPES OF DOCUMENTS (eg. Directive OR Regulation, never both, but can use a workaround, see explanations)
"https://eur-lex.europa.eu/search.html?DTA=" & _
YEAR & _
"&DTC=false&SUBDOM_INIT=ALL_ALL&DB_TYPE_OF_ACT=&DTS_SUBDOM=ALL_ALL&typeOfActStatus=OTHER&DTS_DOM=ALL&orFM_CODEDGroup=FM_CODED=" & _
DOCUMENT_TYPE_SHORT_NAME & _
"&lang=en&type=advanced&DTN=" & _
ZEROES & _
NUMBER
YEAR - same as above
DOCUMENT_TYPE_SHORT_NAME - same as above, only the names of the types of documents you are looking for must be in only one cell / only one set of strings, like this: "NOTICE&FM_CODED=COMMUNIC"
ZEROES - same as above
NUMBER - same as above
|
|
| pus acum 1 an |
|