Share via

Excel 32 bit to 64 bit

Anonymous
2020-08-13T07:52:52+00:00

I have been using Excel 32 - bit thus far. I have switched to a new laptop which has excel 64 bit.... none of the macros / vbas work

I am attaching a snapshot of the error image. Can someone help me resolve this? URGENT

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2020-08-13T07:57:32+00:00

    Hi NavinAgrawal1,

    I am John, an Independent Advisor and a Microsoft user like you. I'm here to work with you on this issue.

    If possible, could you please share a screenshot of the error message? As I do not see any attached file to this post. This would help me to understand your issue much better.

    Awaiting for your response

    Regards,

    John

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2020-08-13T08:24:31+00:00

    Hi NavinAgrawal1,

    Sorry if the attachment did not come through at first. I was able to see it now.

    For this issue, please be informed that all Declare Statements must now include the PtrSafe keyword when running in 64-bit versions of Microsoft Office. The PtrSafe keyword indicates a Declare statement is safe to run in 64-bit versions of Microsoft Office.

    Please declare the PtrSafe keyword to your statements, check the link below for guidance.

    https://docs.microsoft.com/en-us/office/vba/lan...

    For more details, please see: https://docs.microsoft.com/en-us/office/vba/lan...

    I hope it worked out well for you. If not, please reply back to this forum to let me know. I will be glad to follow up and help you further.

    Regards,

    John

    0 comments