We have software (Tekla) which creates report spreadsheets. When opened in Excel these give an error message "The format and extension of <filename> don't match. The file could be corrupted or unsafe. Unless you trust the source, don't open it. Do you want to open it anyway?".
If I click "Yes" it opens fine.
However in a c# application the line:-
workbook.LoadFromFile(currentfile);
gives an error.
Is there any way to simulate the "Yes" response when using workbook.LoadFrom?