Macro to copy an element from HTML code to Excel sheet

Cerrado Publicado hace 5 años Pagado a la entrega
Cerrado Pagado a la entrega

I have a spreadsheet that I would like 2 things done for:

1. I would like to have a macro that automatically runs every "X" number of minutes that will navigate to a website, copy an element from the HTML code (this element is a football scores table found at [login to view URL]) and then paste this back into a specific location in my Excel sheet. I would like the website to stay open once VBA has opened it because there will be no point closing it if the table is going to be copied regularly. However, I would like the macro to always run an IE refresh to ensure the most up-to-date information is being displayed. Within this macro, I would also like a simple macro to run automatically once the data has been copied, which formats columns N, O and P into a custom "d-m" format. I have included a screen shot of the location of the HTML table that needs to be copied. It is the one highlighted in blue.

2. My spreadsheet has a count-up timer code embedded in cell B2 that starts whenever cell B1 is changed. Currently the timer keeps counting up, however, I would like it to stop counting up once it reaches 65 seconds.

Perhaps the easiest thing would be for me to provide a demo spreadsheet for you to create these things in, after which I will copy them into my working sheet. I think this will be simpler as my working sheet has a lot of elements involved that make it a little confusing!

Thanks

Entrada de datos Procesamiento de datos Excel PHP Visual Basic

Nº del proyecto: #17992331

Sobre el proyecto

17 propuestas Proyecto remoto Activo hace 5 años

17 freelancers están ofertando un promedio de $34 por este trabajo

polarjin2017

Hello? How are you? I have good skills in So I can complete your job in time. Hope to work with you. Thank you.

$55 AUD en 3 días
(178 comentarios)
7.2
sargardon

Hello sir/madam I am ready to do your job. I have over 10 years of experience in VBA development and I already built similar macros previously. Please contact me if interested. Best regards, Tolib

$50 AUD en 2 días
(138 comentarios)
7.2
wiisetech

Hi, I have already done a similar job. I can create this macro for you. waiting for your reply to get started. Regards.

$88 AUD en 3 días
(45 comentarios)
4.6
krishnaagr89

Hi,I have read your requirements of Macro to copy an element from HTML code to Excel sheet and I’m pretty confident that I will be able to get your work done within the given time your requirements conclude.I am very k Más

$24 AUD en 2 días
(6 comentarios)
3.1
schandraindya

Hello, I would like to take this opportunity to introduce myself. My name is Satish Chandra and am an expert in Visual Basic for Applications (VBA - Macros) automating complex Excel based reports, having an experien Más

$25 AUD en 1 día
(2 comentarios)
1.6
mejorgabriel

Good afternoon. My name is Gabriel, I am a fifth year student of Computer Engineering. I would love to help you solve your problem. I have experiences (outside this site) making Macros implementations for Excel, in Más

$35 AUD en 2 días
(0 comentarios)
0.0
awanishyadav

I have 4-year experience in MNC company. I am master in CSE. I can handle your project easily. please give me an opportunity.

$25 AUD en 1 día
(0 comentarios)
0.0
karuanura

I am well experienced 10+ years in excel vba, .net, java, html json. This would be my first project if I am selected. Please see my work and pay once completed. Best Regards..

$25 AUD en 1 día
(0 comentarios)
0.0
MLBISHNOI

Hello, sir I am ready to do the work you told me today. You can give me this job right now, I will do this work in less time and with reasonable responsibility. Thank you sir

$25 AUD en 1 día
(0 comentarios)
0.0
bhuraparmar24

i am interested this project. Relevant Skills and Experience i am interested this project.

$30 AUD en 1 día
(0 comentarios)
0.0
Anna20160325

I like modification based on some materials so its fine to provide you the first step timer function.

$25 AUD en 1 día
(0 comentarios)
0.0