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!
18 freelancers are bidding on average $35 for this job
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
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 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..