spreadsheet to automatically update draws of the 6 lotteries.

jack

Member
hello, frank can you help me with this! Please, I need to update the 6 lotteries that I play, that is, create six (6) spreadsheets, in one, with the objective of updating the drawings, then each spreadsheet will have a button where you click and update the drawings automatically on the 6th administrator's website. lotteries address is=

www.caixa.gov.br/loterias the files are in html

in downloads, in the link we have a macro, it has errors, can you correct these errors? please

the 6 lotteries=

Lot(1, 1) = "corner/": Lot(1, 2) = "qnConcursoDate"

Lot(2, 1) = "timemania/": Lot(2, 2) = "tmConcursoDate"

Lot(3, 1) = "douplasena/": Lot(3, 2) = "dsConcursoDate"

Lot(5, 1) = "megasena/": Lot(5, 2) = "msConcursoDate"

Lot(6, 1) = "lotomania/": Lot(6, 2) = "lmConcursoDate"

Lot(7, 1) = "lotofacil/": Lot(7, 2) = "lfConcursoDate"
https://www.mediafire.com/file/gea0g6cmw2ytytr/atualiza+sorteios+na+net.txt/file
 

jack

Member
frank, this macro is an example it is not working, needs to see and improve
the files in the administrator are in html
website= www.caixa.gov.br/loterias
these are the lotteries
site = "http://www.xloterias.com.br/"
you have coo
Lot(1, 1) = "corner/": Lot(1, 2) = "qnConcursoDate"
Lot(2, 1) = "timemania/": Lot(2, 2) = "tmConcursoDate"
Lot(3, 1) = "douplasena/": Lot(3, 2) = "dsConcursoDate"
Lot(5, 1) = "megasena/": Lot(5, 2) = "msConcursoDate"
Lot(6, 1) = "lotomania/": Lot(6, 2) = "lmConcursoDate"
Lot(7, 1) = "lotofacil/": Lot(7, 2) = "lfConcursoDate"
you have to correct the macro it doesn't work, or create another one, with the aim of updating new draws every week, with a button to click, the 6 spreadsheets can be in one, having the lottery name in the bar below the spreadsheet, objective to update the 6 lotteries draws, reminder= in the administrator's draw register, it has the numbers but also other data, ignore! only draw date and numbers ok
 
Top