I have a bunch of .xlsb files I need to pull data out of and migrate to a FileMaker database. The issue I'm running into is some of the files have a macro that runs immediately when the file is opened even through the com object due to the way the macro works.
This is how I'm currently opening Excel files. Does anyone know a way to open an Excel com object in safe mode? Any other way which would prevent the macros from running would also work.
$objExcel = new-object -ComObject excel.application