Excel 64-bit update crashes at SetTimer since lately

reinht 21 Reputation points
2021-09-07T18:47:26.91+00:00

My Excel VBA application supports 32-bit and 64-bit.
The last few Office 365 64-bit updates e.g. 16.0.14326.20262 crash my application at

SetTimer HWnd, 0&, INTERVAL, AddressOf TimerProc

It's the AddressOf command which is responsible for.
My application provides everything which has to do with PtrSafe that it works with Excel 64-bit.
The only chance to overcome the problem is to compile and run the application in exactly this 64-bit Excel built. Another built will crash Excel 64-bit again.
It's not feasible to manage my application versions by each single Excel 64-bit built number.
It worked for long that way that I compiled my application in Excel 32-bit and it run in Excel 64-bit as well.
But recently something changed in Excel 64-bit that it needs VBA compilation for each single built. Again, Excel 32-bit works fine with no restrictions.

Any ideas?

TIA
Reinhard

Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,532 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,649 questions
0 comments
Accepted answer
  1. Viki Ji_MSFT 4,421 Reputation points
    2021-09-08T03:13:55.697+00:00

    Hi @reinht ,
    Welcome to Q&A forum!
    Will this issue occur if you update Office to the latest version?

    From the perspective of Office, please exit all Microsoft Office apps, and then add the following registry key to check this issue.

    • Enter regedit in the Search Windows box, select Registry Editor to open it.
    • Go to HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Excel\Options to create a new DWORD Value. Value Name: ForceVBALoadFromSource
      Value Type: REG_DWORD
      Value Data: 1

    130067-image.png

    • Exit Registry Editor to check this issue.

    If the above do not work, since I am not a VBA expert, I would suggets you refer to the following page to post a new question and provide the detailed code for more professional support.
    Office developer community
    Thanks for your understandin!

    Hope the information is helpful to you.

    If an Answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest