At home I have Excel 2019 (Version 2110). More mysteriously, when I attempted to open them on my HOME computer, they were not recognised. However, although this primary file was now working, a second problem arose. I do not know exactly why this GetKeyState function would have caused the entire Excel file to fail to open - so if anyone has any ideas, I'd like to hear them (I'm aware that I should repeat this post on StackOverflow too) Private Declare Function GetKeyState Lib 'user32' (ByVal nVirtKey As Long) As Integer

Out of interest, the offending line was this: 'Required functions to test the state of the shift key (for developer to pause Launcher) When the (non-critical) line was removed, the file opened properly with my corporate environment. It opened using my home Excel, and I was able to diagnose precisely which line was giving the error. It is not corrputed, because I managed to e-mail the file to myself at home. I know for a fact that there is nothing wrong with the file. Verify that the file has not been corrupted and that the extension matches the format of the file'

'Excel cannot open the file Portal.xlsm because the file format or file extension is not valid. xlam files, which have been split up simply for convenience so the user does not have to load ALL code in one go, but may load files separately according to which section of the application they want to use. It relies heavily on VBA, spread over multiple files. The latest update to MS Office at my corporate workplace has unfortunately broken my Excel application. I'm aware that this may be a bit of an X-Y problem, so I'll start from the beginning.

Microsoft office portable 2019