Lengkap

Scraping Excel macro needs fixing - HAS TO BE DONE IN NEXT 2H

Hi,

We have a simple Excel VBA scraping code, getting data from [login to view URL], part of which stopped working recently due to small changes in website structure.

We need someone to identify the error and get the macro to work again

This need to be finished within next 2H.

Please find code attached below

Part of the code which is responsible for macro not getting data properly:

myDateScraped = Mid(myGetDateHTML, InStr(myGetDateHTML, "showDate") + 14, 2) & "-" & Mid(myGetDateHTML, InStr(myGetDateHTML, "showDate") + 19, 2) & " " & _

Mid(myGetDateHTML, InStr(myGetDateHTML, "showDate") + 22, 2) + 1 & ":" & Mid(myGetDateHTML, InStr(myGetDateHTML, "showDate") + 25, 2)

Kemahiran: Pemasukan Data, Excel, PHP, Visual Basic, Pengikisan Web

Lihat lagi: web scraping excel macro, build a website coding need to be done in dotnet, but it has to be coded with classic asp, excel macro not working, excel macros, excel vba not working, how to enable macros in excel, macros not working in excel 2016, excel macro stopped working, how to solve macro problem in excel, macros not working in excel 2013, design a logo that has to be modern and related to it, i have 500 pdf to be transcribed in excel in 10 different fields need it quick!, i need 7 pages to be converted from psd to html (no need to be responsive) i need it to be done in 1 days please share your skyp, i need 7 pages to be converted from psd to html no need to be responsive i need it to be done in 1 days please share your skype , what need to be done in marketing, A fully functioning website for Nelson Beer Week, which needs to be done in Joomla., Simple website needs to be developed in PHP framework, this website has two different types of logins, Need a 2 second very basic logo animation of a lizard walking diagonally across the logo. images supplied. Needs to be done in A, has to be done means

Tentang Majikan:
( 10 ulasan ) Krakow, Poland

ID Projek: #19080619

Dianugerahkan kepada:

ilkecokay

Sponsor My Bid BE THE FIRST BID SEEN BY THE EMPLOYER Bids that are sponsored are 518% more likely to be awarded. Stand out from the rest of the freelancers, by being pinned to the top of the employer's bid list. There Lagi

$2 USD / jam
(59 Ulasan)
5.2

12 pekerja bebas membida secara purata $9/jam untuk pekerjaan ini

TonmoyRoy111

Dear client, I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Kindly contact me. Roy

$12 USD / jam
(310 Ulasan)
6.7
mail2vimalarora

Hello, I am ready to discuss project with you. Being experienced in working on several excel vba projects, based on that I can help you in getting it done quickly. I am available to start now and want to discuss mo Lagi

$10 USD / jam
(115 Ulasan)
6.0
sujoymondal87

I can do it asap..and can start right now..let me know in freelancer chat.. also please mention taht which column is missing

$8 USD / jam
(25 Ulasan)
5.5
gorpoghosyan

Hallo)) I am Gor from Eastern Europe, Armenia. I reviewed your job post and I am too eager to cooperate with you having a guarantee my strong skills and vast experience. I am a specialized web developer comfortable Lagi

$38 USD / jam
(27 Ulasan)
5.4
nvchien94

Hello there, I am an VBA coder with many projects in scraping. I can support you in next 2 hours. Please contact I will start now. Thank you.

$7 USD / jam
(61 Ulasan)
4.8
ankitdavda2012

Hello, I can resolve your problem in 2 hours as you mentioned in job description. I have 4+ years experience in Development. Thanks Ankit

$8 USD / jam
(14 Ulasan)
3.9
stanleyw12

Hi Sir/Mdm Thanks for reviewing my application. I am well versed in VBA having used it in various financial institutions. As I am a new freelancer, I am willing to do this job at a cheap cost or even for free. Pleas Lagi

$2 USD / jam
(8 Ulasan)
2.1
anishadavid16

I am a final year post graduate student in computer applications and i am a BCA graduate wherein i have done many projects both back end and front end using various software tools where data formulation , maintaining Lagi

$5 USD / jam
(0 Ulasan)
0.0
hamzaarshadhaj98

i new to Freelance.. give me chance to done your job. i need a chance i happily do it as minimum wages i can for you

$2 USD / jam
(0 Ulasan)
0.0
Rjnj

Hudson Agile Technologies LLC – A New Jersey Firm. Entity ID – 0450219485 We are head quartered in 30 Knightsbridge Rd Suite 525, Piscataway Township, NJ 0885 We are a Software Technology Outsourcing consulting Lagi

$5 USD / jam
(0 Ulasan)
0.0
paulocroman

Hi. I found the problem in the VBA code you provided. If you want to proceed let me know. I am an experienced (+15 years) VBA coder.

$10 USD / jam
(0 Ulasan)
0.0