Excel VBA & macro scripting for Windows 1O environment

I have 4 excel macros running on windows 7 that need to be rebuilt so they will run correctly on windows 10 system. Issues to be resolved: 1) auto run the Excel tasks every 3 hrs (using Windows Task Scheduler - or other app(?) if Task Scheduler is not stable) 2) avoid memory leaks 3) ensure that data imported from source CSV's is fully loaded before running excel functions 4) provide notes so I can then make minor adjustments in the future if the base files change What the scripts need to do: A) import data from 2 CSV files. Must be stable for up to 100,000 rows of data and up to 20 columns of data. The CSV data is basic inventory from a POS system (SKU | Price | QOH Store 1 | QOH Store 2 | QOH Store 3, etc) B) merge supplied CSV data into single QOH report and save as CSV: SKU | Price | Combined QOH | Availability Text String C) CSV being generated will be overwritten every 3 hrs with new CSV from the excel script I will supply current Excel Files and support CSV files. The "HB" set works fine in Windows 7 environment, but causes memory leaks (so machine has to be restarted daily). The "TTL" set keeps failing to import all CSV data records before running remaining excel macros) currently running: Files/HB/POS Sync Files/[login to view URL] Files/HB/POS Sync Files/[login to view URL] Files/TTL/SCRIPTS/TTL-INV [login to view URL]