Macro to copy an element from HTML code to Excel sheet
$10-30 AUD
Paid on delivery
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
Project ID: #17992331
About the project
17 freelancers are bidding on average $34 for this job
Hello? How are you? I have good skills in So I can complete your job in time. Hope to work with you. Thank you.
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
Hi, I have already done a similar job. I can create this macro for you. waiting for your reply to get started. Regards.
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 More
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 More
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 More
I have 4-year experience in MNC company. I am master in CSE. I can handle your project easily. please give me an opportunity.
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..
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
i am interested this project. Relevant Skills and Experience i am interested this project.
I like modification based on some materials so its fine to provide you the first step timer function.