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