Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Excel 2016 For Mac 64-Bit Update - 'Internal Errors' #477

Open
LawrieMcintosh opened this issue Aug 4, 2022 · 0 comments
Open

Excel 2016 For Mac 64-Bit Update - 'Internal Errors' #477

LawrieMcintosh opened this issue Aug 4, 2022 · 0 comments

Comments

@LawrieMcintosh
Copy link

Hi Tim

Once again, appreciate all your hard work on this code, its a great library.

Note This may be just an extension of issue 248, but as this issue is closed I think I'm meant open a new one
#248

I think i've tracked down another bug, seeming related to mac compatibility
mac OSx Big Sur v11.4
Excel 16.63.1
Microsoft visual basic for applications 7.1

Error is with line 73 of webhelpers:
AutoProxy_fAutoDetect As Long

And as far as i can tell, the issue is with the "Long", perhaps with all such Longs...

(I started re-creating this module chunks of code at a time as the failure mode is a little elusive) I had to save the file, close and re-open excel and try to continue editing the code before the error would show up.

Alert: "An unexpected error has occurred. Auto-recovery has been disabled for this session of Excel."

Further attempts to run code or to remove the module at this point results in a Microsoft visual basic internal error, and macros will not run again in this file (need to revert to an earlier backed up version).

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant