Lukket

Macro to copy an element from HTML code to Excel sheet

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

Evner: Dataindførsel, Databehandling, Excel, PHP, Visual Basic

Se mere: macro update log files status excel sheet, html code excel, html access excel sheet, copy web page information excel sheet, converting oracle 11i html reports excel sheet, copy paste html tags excel, macro copy part cell content excel, macro copy currently open html page excel spreadsheet, custom code excel sheet name, code excel sheet processing, extract html code excel macro, macro copy html excel internetexplorer, excel macro copy next sheet, convert html code style sheet, copy data web site table excel sheet vb code, copy paste html pages excel, convert excel html code excel vba code, copy pdf file name excel sheet, add state code excel sheet, copy wix html code

Om arbejdsgiveren:
( 2 bedømmelser ) Bristol, United Kingdom

Projekt ID: #17992331

18 freelancere byder i gennemsnit $35 på dette job

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 in 3 dage
(106 bedømmelser)
6.7
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 in 2 dage
(128 bedømmelser)
6.8
$30 AUD in 2 dage
(56 bedømmelser)
5.1
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 in 3 dage
(42 bedømmelser)
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 Flere

$24 AUD in 2 dage
(6 bedømmelser)
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 Flere

$25 AUD på 1 dag
(2 bedømmelser)
1.6
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 på 1 dag
(0 bedømmelser)
0.0
tomajas

. . . . . Flere

$50 AUD in 5 dage
(0 bedømmelser)
0.0
$10 AUD in 3 dage
(0 bedømmelser)
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 på 1 dag
(0 bedømmelser)
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 på 1 dag
(0 bedømmelser)
0.0
$26 AUD in 3 dage
(0 bedømmelser)
0.0
$35 AUD på 1 dag
(0 bedømmelser)
0.0
bhuraparmar24

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

$30 AUD på 1 dag
(0 bedømmelser)
0.0
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 Flere

$35 AUD in 2 dage
(0 bedømmelser)
0.0
alexihrndz

Hola, hice un proyecto muy similar hace un año revisa aquí [login to view URL]

$50 AUD in 5 dage
(0 bedømmelser)
0.0
Anna20160325

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

$25 AUD på 1 dag
(0 bedømmelser)
0.0
$15 AUD in 2 dage
(0 bedømmelser)
0.0