Update: for whatever reason, the fix was to remove the reference to Excel Type Object Library 16.0 debug, and then add the reference back in and lo and behold, it suddenly works!