Find Jobs
Hire Freelancers

Excel VBA macro sheet using REST

$30-250 USD

Închis
Data postării: aproape 9 ani în urmă

$30-250 USD

Plata la predare
I have a small Excel VBA workbook that currently gets information fro a database via a DLL. I need it adapted to get this information via REST JSON. The existing worksheet has a column of names of database records.. The VBA code is triggered when a date is selected. The code loops through the products and requests prices for that date ( and 1 other) & puts them in a cell beside the product code. That is it, really simple. The first job will be to see if user has access to all these product names by getting a JSON customer record and checking all symbols against this. If none are available we tell the user and do nothing else. If some are available we warn user and ask to continue. If everything is Ok, the VBA will have to read the list of record names from the worksheet, add the date and, using REST/JSON, request prices then Display result in cells in Excel workbook (in same row as the record name). The code needs to be robust code and handle all errors well. Failing to connect etc. I'll supply API details to successful bidder. Let me know what libraries you will use and how quick you can deliver please. This may lead to a second larger job. You MUST have: VBA and REST experience ESSENTIAL. Availability through the day via Yahoo Messenger/skype Fluent English Relevant Demo will impress. Possibility of more work. Thanks
ID-ul proiectului: 7877456

Despre proiect

12 propuneri
Proiect la distanță
Activ: 9 ani în urmă

Vrei să câștigi bani?

Avantajele de a licita pe platforma Freelancer

Stabilește bugetul și intervalul temporal
Îți primești plata pentru serviciile prestate
Evidențiază-ți propunerea
Te înregistrezi și licitezi gratuit pentru proiecte
12 freelanceri plasează o ofertă medie de $212 USD pentru proiect
Avatarul utilizatorului
I want to discuss this project with you further, let me know the best suitable time for you to schedule the meeting, Feel free to message me at any time, i used to be online 14 hrs in a day on this website so probably you will get a quick response from my end.
$309 USD în 10 zile
4,7 (35 recenzii)
6,2
6,2
Avatarul utilizatorului
Hi, I have lots of experience with VB6 and REST also. I have written many network enabled vb applications and can help you with this project.
$277 USD în 7 zile
4,9 (12 recenzii)
5,1
5,1
Avatarul utilizatorului
HI, I'm very proficient in VBA and Excel. I have taken a look at your project description, and I know I can do it. Check my profile and portfolio, award me now. Thanks
$222 USD în 3 zile
4,9 (30 recenzii)
4,8
4,8
Avatarul utilizatorului
Hello, Actually I was finishing one add-in for Outlook when noticed this post. It is 4AM so I may fail to write a nice proposal here :( I would go with built-in MSXML component. I've used it many time and I will mention some of them here: - for auto-posting ads on couple classifieds websites requiring communication with multiple web servers (home server, classifieds websites, captcha solver service and (sometimes) my own web server allowing my crew to enter captcha's); I can provide screenshots once you initiate chat. - dealt with retrieving exchange data from Yahoo finance and similar... Also please check out my profile here at this freelancing website. What about speed? Depending on how many products and request you may want to submit I may have a solution for that as well (done it before and can provide a screenshots; I may have video as well somewhere on youtube): multi-threading .NET application involving VB.NET and Excel. A multi-threading app would be a little more expensive due to its complexity but I would let you offer the price :) Thank you for reading. Kind Regards
$198 USD în 3 zile
5,0 (9 recenzii)
4,6
4,6
Avatarul utilizatorului
Hello sir/madam, However, I am new here in freelancer.com I have over 10 years of experience in VBA and .Net programming. Let me do your job as an Excel add-in using C#. This way you will combine Excel with power of modern languages like C#. I have developed several such plugins including integration with JSON and ready to demonstrate you them. Please contact me to discuss the details. Waiting for your messages. Best regards, Tolib Rahimov
$180 USD în 3 zile
5,0 (36 recenzii)
4,6
4,6
Avatarul utilizatorului
I have 7+ years expereince in VBA and have moderate experience with RESTful APIs. I will be available in skype for discussion time to time. I am working in JST timings.
$150 USD în 7 zile
5,0 (1 recenzie)
1,4
1,4
Avatarul utilizatorului
Hi, I am an Experienced professional in developing Excel VBA's for fetching data through API. I use MSXML.DLL. I will try to deliver VBA by 7 days, but will update the exact time after assigning the project. I guess I am the best suitable freelancer for your project.
$125 USD în 3 zile
5,0 (2 recenzii)
1,2
1,2
Avatarul utilizatorului
A proposal has not yet been provided
$233 USD în 3 zile
0,0 (0 recenzii)
0,0
0,0
Avatarul utilizatorului
VBA Excel macro programming Expert, can do this project with all requirements specified. Can work on Weekend and Weekdays to complete this project.
$222 USD în 3 zile
0,0 (0 recenzii)
0,0
0,0

Despre client

Steagul UNITED KINGDOM
Feltwell, United Kingdom
5,0
176
Metoda de plată a fost confirmată
Membru din iul. 12, 2004

Verificarea clientului

Mulțumim! Ți-am trimis prin e-mail linkul pe care trebuie să-l accesezi pentru a revendica creditul gratuit.
A apărut o eroare la trimiterea e-mailului. Încearcă din nou.
Utilizatori înregistrați Totalul proiectelor postate
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Se încarcă previzualizarea
S-a oferit permisiunea de depistare a locației.
Ți-a expirat sesiunea pentru conectare sau te-ai deconectat. Conectează-te din nou.