I'm attempting to automate the opening a large number of files, each file is then processed and logged. However I've run into an issue when a file links to an encrypted spreadsheet. Even though I have links set to never update on opening the spreadsheet,
the application stops and opens up a visible instance of excel requesting the password for the encrypted file. Is there any way to bypass this. The processing I'm doing does not require the links to be updated.
I've attempted placing the opening of the Excel file in a separate thread and limiting its time allowed to open, but while my code throws the expected TimeoutException, the Excel instance(with password screen) remains.
View Complete Post