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
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.
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
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
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
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.
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.