Find Jobs
Hire Freelancers

Solve Duplicating problem (VBA MACRO)

$10-30 USD

Fullført
Lagt ut over 5 år siden

$10-30 USD

Betalt ved levering
I have a VBA Macro for scraping data off of a website. The issue is that it comes with duplicates in the excel sheet. I have tried to adjust wait time but this is on and off - works/doesn't work. Need a permanent solution for this so that the VBA just gets the data without duplicates. State your approach to this task and I will hire you.
Prosjekt-ID: 17539416

Om prosjektet

13 forslag
Eksternt prosjekt
Aktiv 6 år siden

Ønsker du å tjene penger?

Fordeler med budgivning på Freelancer

Angi budsjettet og tidsrammen
Få betalt for arbeidet ditt
Skisser forslaget ditt
Det er gratis å registrere seg og by på jobber
Tildelt til:
Brukeravatar
Hello! This is Sourabh Gupta from New Delhi. I am an advanced Excel VBA programmer currently at the post of Forum Expert at [login to view URL] (username - sourabhg98) with over 400 questions answered and 1100 reputation points. I would like to offer my services for this project. I can try fixing the duplication issue on your worksheet. Actually waiting as you described is not a permanent solution. However, we can wait until a specific element is loaded. However, I would really need to have a look at your code and the website to see what exactly is getting duplicated and why. I assure the best in class services and fairest prices. Do consider me once, won't dissapoint you. Would wait for a positive and prompt response from your side :) Regards Sourabh
$25 USD om 1 dag
5,0 (122 omtaler)
5,7
5,7
13 frilansere byr i gjennomsnitt $33 USD for denne jobben
Brukeravatar
Hello, I can help with you in your project Solve Duplicating problem (VBA MACRO) I have more than 5 years of experience in Data Processing, Excel, PHP, Visual Basic, Visual Basic for Apps. We have worked on several similar projects before! We have worked on 380+ Projects. Please check the profile reviews. I can deliver your job with in your deadline. Please ping me for more discussion. I can assure the 100% job satisfaction. Thanks,
$50 USD om 2 dager
4,9 (368 omtaler)
8,0
8,0
Brukeravatar
I have excellent command on MS Excel and can solve the duplicating issue. Approach can be decided only after looking at the macro, so please share the file
$30 USD om 1 dag
4,9 (104 omtaler)
6,1
6,1
Brukeravatar
Dear Client, Before Awarding to Anyone give me a chance & kindly discuss your project in detail with me. I have read your requirement carefully and got total understanding of the project .No fake commitment,100% quality work. I have more than 8 years of experience in IT Services. I am always available on Email, WhatsApp and Skype. Please have a voice or video chat if necessary. I will be available more than 40 hours per week and able to start your project immediately after finalization. Thank you for taking the time to read my application. I look forward to talking with you. Regards Nikhil Singh
$15 USD om 1 dag
4,7 (46 omtaler)
5,1
5,1
Brukeravatar
am not a random bidder... I have 16 years of expertise with various project exposure.. Please visit my profile for more details.. thank you..
$100 USD om 1 dag
4,9 (29 omtaler)
5,1
5,1
Brukeravatar
Hello I have build numerous web scraping apps using VBA and I believe I can help you. I will have to examine your code before I can a give a better description to what my approach will be. Don't hesitate to contact me with any question you might have. Thanks for reading. Best regards, Michael.
$30 USD om 1 dag
5,0 (34 omtaler)
4,3
4,3
Brukeravatar
Hello I’d be able to help with your issue. My approach is dependant on seeing the macro work myself, however I would probably take one of two approaches: 1) use a remove duplicates function on the data 2) bespoke formula to work through data straight after its downloaded I have over 10 years experience with excel/vba for a global financial services firm where I automated many processes to create efficiencies and improve profitability. I’m sure I have the relevant experience to solve your issue. I hope to hear back from you soon. Kind regards Steve
$30 USD om 1 dag
5,0 (8 omtaler)
3,9
3,9
Brukeravatar
Do you use SeoTool to do a scrape or your own build tool. Send me your file I will take a look. Thank anyway
$25 USD om 1 dag
5,0 (3 omtaler)
2,3
2,3
Brukeravatar
Hello, I have 16 years of Experience in Excel sheet and I can easily fix your problem in a few hours. I look forward to hearing from you. Thanks Sounak
$20 USD om 1 dag
0,0 (0 omtaler)
0,0
0,0
Brukeravatar
I am : - Big picture thinker, talented and driven to impact the bottom line profitability while ensuring staff compliance to business policies & procedures. - Advanced commercial business consultant & developer, skilled provider of on-job training, guidance and motivation that result in retention of top performance professionals. - Advanced communicator & cultivator of key relationships with all levels of personnel, clients, business as well as executive managers
$25 USD om 1 dag
0,0 (0 omtaler)
0,0
0,0
Brukeravatar
Hi there, I have been working with Excel for over a decade. I specialise in linking Excel with other applications. I am new to Freelancer but have been active on Furums since 2008. I would first see if I can fix the issue by looking at the readystate of the ie window, then I could look at excluding items by using a collection object in VBA which will not allow duplicates to be added. Failing this the duplicates could be removed after the data has been scraped or I may completely re-write the Macro that collects the data. Hope this makes sense Regards George
$20 USD om 2 dager
0,0 (0 omtaler)
0,0
0,0
Brukeravatar
Hello, nice to meet you. I am an expert in programming with a little knowledge in algorithms. I carefully read your description and I am very interested in your project. I have two solutions about your problems: - The first one is to update the VBA code to remove duplicates. If there is no suitable functions to remove duplicates, I can make it possible to check duplicates by using some algorithm tricks (more details can be shared in chat). - Second one is to make an extra program to sanitizing the result. This is quite easier that the first one but I am not sure if you can accept it. Let's talk about the project in more details. Thank you for your attention. I am waiting for your reply.
$25 USD om 1 dag
0,0 (0 omtaler)
0,0
0,0

Om klienten

KENYAs flagg
Nairobi, Kenya
5,0
25
Betalingsmetode bekreftet
Medlem siden sep. 22, 2016

Klientbekreftelse

Takk! Vi har sendt deg en lenke for at du skal kunne kreve din gratis kreditt.
Noe gikk galt. Vær så snill, prøv på nytt.
Registrerte brukere Publiserte jobber
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Forhåndsvisning innlasting
Tillatelse gitt for geolokalisering.
Påloggingsøkten din er utløpt og du har blitt logget ut. Logg på igjen.