I gang

Small changes to Excel VBA script

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.

Evner: Excel, Visual Basic, Databehandling, HTTP, JSON

Se mere: excel vba lock sheet user script, start vba script excel, run vba script excel, excel vba script modify existing vba, vba script excel xml, excel vba lookup script, script install excel vba, vba script excel current worksheet, excel vba return results plsql script, vba script project excel, can vba script run outside excel, simple excel vba script, excel using custom vba script, excel vba script find text, excel nearest neighbor vba script, excel vba script merge cells, excel vba script scrape website, excel vba script copy paste, excel vba script

Om arbejdsgiveren:
( 0 bedømmelser ) Brussels, Belgium

Projekt ID: #20298858

Tildelt til:

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 Flere

€50 EUR in 3 dage
(60 bedømmelser)
5.1

34 freelancere byder i gennemsnit €101 på dette 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. Flere

€160 EUR in 2 dage
(331 bedømmelser)
7.9
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 dage
(148 bedømmelser)
6.9
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 Flere

€200 EUR in 7 dage
(224 bedømmelser)
6.9
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 Flere

€125 EUR in 2 dage
(118 bedømmelser)
7.2
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 Flere

€100 EUR in 3 dage
(79 bedømmelser)
6.7
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 Flere

€70 EUR på 1 dag
(83 bedømmelser)
5.9
mtdevil369

Hi, I am having good knowledge on excel,micros and VBA module development. I have developed many automation process in excel. I am able to develop your process as well. Please come on freelancer chat to discuss many mo Flere

€94 EUR på 1 dag
(121 bedømmelser)
5.9
aubrey03

I am an Excel and VBA specialist with a lot of experience in creating complex automation tools, formulas, databases, queries and macros. You may check some of my projects here: [login to view URL] Flere

€120 EUR in 2 dage
(109 bedømmelser)
5.8
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 Flere

€100 EUR in 7 dage
(32 bedømmelser)
5.3
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 dage
(9 bedømmelser)
5.0
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 Flere

€90 EUR in 3 dage
(22 bedømmelser)
4.2
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 dage
(10 bedømmelser)
4.2
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 på 1 dag
(8 bedømmelser)
4.2
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 Flere

€140 EUR in 7 dage
(3 bedømmelser)
3.9
ganeshrasekar

I can do it

€100 EUR in 7 dage
(4 bedømmelser)
3.9
dungforever

Hi. ⭐⭐⭐ I can complete your project in 1 day ⭐⭐⭐ I've read your requirements carefully. I understood your requirement and I have full experience in Excel VBA. I am a certified freelancer with great ideas & methodologie Flere

€100 EUR in 7 dage
(5 bedømmelser)
3.7
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 dage
(6 bedømmelser)
3.4
sergeyprince

Hello. I can do your project perfectly. I have got 8 years of rich experience in VBA. I can do VBA programming as fast as you want. I am Data Processing, Excel VBA Expert who knows the value of time, very hard workin Flere

€100 EUR in 7 dage
(10 bedømmelser)
2.7
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++ Flere

€200 EUR in 7 dage
(3 bedømmelser)
2.8
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 Flere

€40 EUR in 2 dage
(6 bedømmelser)
2.4