Macro to copy an element from HTML code to Excel sheet

$10-30 AUD

Lezárt

Kiadva ekkor:

több mint 5 évvel ezelőtt

$10-30 AUD

Teljesítéskor fizetve

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

Projektazonosító: 17992331

A projektről

17 ajánlat

Távolról teljesíthető projekt

Aktiválva: 5 évvel ezelőtt

Szeretne pénzt keresni?

E-mail cím

A Freelancer oldalán történő árajánlatadás előnyei

Határozzon meg költségvetést és időkeretet

Kapja meg fizetését a munkáért

Vázolja ajánlatát

Ingyen regisztrálhat és adhat árajánlatot munkákra

17 szabadúszó adott átlagosan $34 AUD összegű árajánlatot erre a munkára

@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 3 napon belül

4,9

(178 értékelés)

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 2 napon belül

5,0

(138 értékelés)

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 3 napon belül

4,5

(45 értékelés)

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 keen to discuss further. You can reach me at any time on online . I have also a few clarifying questions on the project.I’m an Expert, Honest, Sincere, Quick learner and Responsible worker as I’m taking my work like my Responsibility. kind regards.

$24 AUD 2 napon belül

5,0

(6 értékelés)

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 experience of 18 years. My other accomplishments are - Am and an expert in writing complex Excel based macros with 15+ years of experience. - Have held several senior level positions during my professional career spanning over 18 years. - Have around 5 years of experience handling 8 teams concurrently PAN India as a Senior Manager. - An expert in data visualization tools like Tableau. - Developed a few applications in Android Studio for Android platform which involves writing code in native Java and XML. - Have also successfully completed the course in PMP from Simplilearn earning 35 Personal Development Units (PDUs). Exam is scheduled on 4th December, 2018. - Have keen interest in Six Sigma, TQM and management methodologies like PDCA, Herzberg's X and Y theory, McGregor's Hygiene theory and am a protagonist of Kanban, Kaizen and Continuous Improvement. - Have scored 7 out of 9 in IELTS certification. - Have been certified for Java, HTML, CSS, JavaScript, jQuery, PHP and mySQL by the Cambridge Certification Authority. My niche is that if any error/glitch is present in the project, I will provide support for it up to 15 days post final payment or submission of the project (whichever date is earlier), free of Cost. Thanks & Regards Satish Chandra +91-9999986050

$25 AUD 1 napon belül

4,8

(2 értékelés)

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 work environments, data processing. The work you propose motivates me, which is an extra point in finishing it as soon as possible and in the best way. I estimate two days at the most, but it could be less. I would like us to be able to communicate to refine my understanding of your needs. I am available for what you need. Greetings, Gabriel Candia. PS: Although I still do not have experience in this site, it is a point in favor given that I am in the possibility of generating a good image for the future. It also encourages me.

$35 AUD 2 napon belül

0,0

(0 értékelés)

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 1 napon belül

0,0

(0 értékelés)

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 1 napon belül

0,0

(0 értékelés)

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 1 napon belül