We want to schedule some spreadsheets to automatically open, refresh query data, then save and close. This will require a Visual Basic script and Excel Macro running in conjunction with each other. You should be aware that there is a lot of data to be refreshed and also a lot of calculations that occur subsequent to the data refresh, so the spreadsheet cannot save and close before everything is done.
In one case, we need to save the spreadsheet as an excel file and also save one of the sheets as a csv file.
We have code developed, but we need someone to tweak it so that everything works properly. We've attached images of what we have already.
16 freelancers are bidding on average $58 for this job
Hi I would like to work on your project. I hope you will be fully satisfied after completing this project with me. Relevant Skills and Experience VBA Proposed Milestones $30 USD - project