Small changes to Excel VBA script
€30-250 EUR
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.
Project ID: #20298858
About the project
26 freelancers are bidding on average €108 for this job
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
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
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
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
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
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
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
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
I have many experiences in vba, rest api. I can show you my projects via chatting. I can complete your project successfully. Thanks.
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
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
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
Hello, i have ability convert your excel file to web application as your retirements Thanks Best regards
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