Instead of hunting for a DLL, Maya followed these steps:
– In Excel VBA editor, Tools → References → Uncheck broken “MISSING: Microsoft Excel 16.0...”, then re-add. Microsoft Excel 16.0 Object Library Dll Download -
Visual Studio will generate an Interop assembly ( Microsoft.Office.Interop.Excel.dll ). Instead of hunting for a DLL, Maya followed
(no download needed)
Microsoft provides free, time-limited VMs with preinstalled Office for testing automation. Google “Microsoft Edge VMs” (these include Office). Instead of hunting for a DLL