![]() ![]() 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. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |