Every single day i have to go to this website http://www8.tjmg.jus.br/juridico/diario/index.jsp and collect the text that is inside all of the "Instância/Foro"(starting from "Interior") and put it in word. I have to do all the labor with "ctrl+c" "ctrl+v". Lately, i was studying about VBA, and i think there is someway i could assemble a macro to enter inside the links and copy the stuff i need.
All the links are almost the same something like this "http://www8.tjmg.jus.br/juridico/diario/index.jsp?dia=2911&completa=interior%7C0002" the only things that change are the "dia=2911" that refers to the day and the month and "interior%7C0002" that refers to the code of the index.
Also, i need the macro to catch things only by the word COMARCA, and if the word isn't there (if the index is empty there is a message, or some bug that makes the word COMARCA to don't appear), i need it to not copy and make a list of the ones with the problem.
Submit an article or tip