Small changes to Excel VBA script

Completed Posted 4 years ago Paid on delivery
Completed Paid on delivery

The Excel VBA works in three steps:

1/ Connect to webserver and retrieve data in sets of 50 rows

2/ Extract data with JSON parser

3/ Store data in Excel table

Currently: the Excel VBA is fully operational and stable.

The Excel VBA collects data from a webserver through a REST API. The Excel uses standard libraries to connect and retrieve the rows of data.

The Excel uses a JSON parser to extract the selected items from the rows of data.

Requested changes:

--------------------------------

1/ The While-Do loop is inverted and should be a Do-While.

In order to parse through the multiple sets of 50 rows a While-Do loop has been added. In the event of more than 50 rows, the script must start another query to retrieve the next set of rows. However, I think that the code could be cleaned up by inverting the loop into a Do-While

2/ The resulting Tables must be cleaned up

2.1/ Remove table filter before update

The data has been stored in a Excel table. If there is a filter active in the table when a refresh is started then the table is not updated correctly. Sometimes this results in blank rows in the table after update. Or other times the new rows are not appended to the table. So, I would like to have the filters automatically removed before the start of the refresh

2.2/ Add Total row

I would like to add a total row for the colums with numerical values.

In attachment the Excel with VBA. Thanks for your consideration

Since you can't connect to the webserver you won't be able to test your VBA changes yourself. I will have to execute on my side. As a consequence some back and forth is to be expected. But it should be minimal.

Excel Visual Basic Data Processing HTTP JSON

Project ID: #20298858

About the project

26 proposals Remote project Active 4 years ago

Awarded to:

Taisho

Hello, the request to add a total row to the table and remove the table filter if it exists before data output is fairly straightforward. About the inverted loop: the loop starts from the total number of rows and decr More

€50 EUR in 3 days
(64 Reviews)
5.3

26 freelancers are bidding on average €108 for this job

schoudhary1553

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. More

€160 EUR in 2 days
(400 Reviews)
8.1
sumon355

Hello, As an experienced VBA developer, i am very much interested to do the required changes in your excel. Looking forward to have a positive response from you. Thanks

€120 EUR in 3 days
(166 Reviews)
7.1
zekovicm

Hi there,I am Excel VBA expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this project ! I can start immediately and finish it within the ag More

€125 EUR in 2 days
(150 Reviews)
7.5
elqueabandona

Hello, my name is Cristian, i am Excel/VBA expert. I am in the top 5 of freelancers in this area and i have more than 240 projects successfully completed here. i work alone, i do not have a team or outsource the proje More

€200 EUR in 7 days
(289 Reviews)
7.2
sloker18

With respect to this project I would like to present myself as a candidate for your consideration. I am proficient with Microsoft Excel and macro/VBA development. I read your project descriptions carefully. I checked t More

€70 EUR in 1 day
(119 Reviews)
6.5
chriskerpini

Hello, My name is Chrys. As you can see from my profile, I have 18+ years experience working with Excel/VBA and 14 years teaching them both (all levels). I can certainly do excellent work with your project. Please con More

€100 EUR in 3 days
(77 Reviews)
6.7
valor312

VERY EASY FOR ME Hi, Nice to meet you. I can do it within a few hours When it comes to Excel, I am an expert Please see product I made recently using VBA and C#, python, java, excel management https://www.freelancer.c More

€100 EUR in 7 days
(58 Reviews)
6.2
writingapp

Hi. Great app writer for your projects. I have writen excel app, macro, vba for many years. I am ready to write your project. Thank you for visiting my profile

€80 EUR in 3 days
(66 Reviews)
5.5
desconit

Hi I have over 11 years of industry experience in Excel and MS-Access development. I can do these changes quickly. Please confirm if you want to proceed. Thanks Farooq

€77 EUR in 3 days
(10 Reviews)
5.0
bluesea1990

Hello Dear I have read your description carefully. I have full experience in Excel VBA and Web scraping. please check my review. I hope to discuss more via chatting. thanks

€200 EUR in 1 day
(17 Reviews)
4.7
ielucerotrad1

I can do the job! Required modifications seem relatively straight forward. I'm an engineer with advanced working knowledge and experience (over 15 years) in Excel and VBA including interaction between different softwar More

€40 EUR in 2 days
(24 Reviews)
4.4
idragon712

Hello I have read your description carefully and I am very confident I can provide you the best results. I am a senior software developer and I have rich experiences in VBA and C#. Specially , I am very familiar with E More

€140 EUR in 7 days
(4 Reviews)
4.1
xinglong717

I have many experiences in vba, rest api. I can show you my projects via chatting. I can complete your project successfully. Thanks.

€140 EUR in 7 days
(11 Reviews)
4.2
webanis

Hello! I am very interested in your post project. I am really looking for this kind of project for a long time in freelancer since i have rich experience on it. I think this project is very suitable for me and i am su More

€90 EUR in 3 days
(24 Reviews)
4.2
fastestJohn

Hello. I have just read your proposal and I am really interested in your project. I'm a full-time developer. https://www.freelancer.com/u/fastestJohn I have enough experiences in Excel and VBA. I can also inject C++ More

€200 EUR in 7 days
(3 Reviews)
2.8
NoSonforhim

Hello, I read your project description and understand all. I have rich experience in Excel VBA and Macros. I will make the perfect product what you want. I promise to complete your project within your time and budget More

€100 EUR in 3 days
(2 Reviews)
1.5
BlackEagle86

Hi, High talented CopyWriting, Article writer, Data Entry, VBA, Access, Microsoft Office, Java, Python and R, C#, C++, QT expert is here! I have read your proposal very carefully and I have come to learn to that job More

€30 EUR in 7 days
(0 Reviews)
0.0
alexestore

Hello, i have ability convert your excel file to web application as your retirements Thanks Best regards

€30 EUR in 7 days
(0 Reviews)
0.0
tsft

Dear Sir or Madam: I am an expert in VBA APPS, I could analyse and resolve your code. I am working with VBA since 90s. I will need access to the web from my PC (if filter or credential needed I will need to see the en More

€120 EUR in 7 days
(1 Review)
0.0
dareen2019

Hello, #name (Thank you for your detailed description) . (I can finish the initial version with perfection within #x days. ) (Before I can estimate the time for this task, I need to know the answer of these questions: More

€140 EUR in 2 days
(0 Reviews)
0.0