Share via

Running VBA Code created in "32 bit Excel" on Windows 10 "64 bit Environment"

Anonymous
2020-12-02T18:42:24+00:00

Dear Colleagues,

Hope you are doing,

Running VBA code created in 32 bit excel version 2016, meanwhile I moved to 64 bit Windows Version but excel version still 32bit. 

After moving to 64bit Windows 10, I’m getting a lot of (Run time error 13 & Run time error 91 object variable or with block variable not set). VBA run in Internet Explorer (IE 11), also I tied to add DoEvent & Application.wait, but sometimes it’s working and sometimes is not. (Library is referred to WOW64).

More information below:

  1. Old Laptop:
    • Windows 7 (32bit)
    • Excel Version 2016 (32bit)
    • IE 11
  2. New Laptop:
    • Windows 10 (64bit)
    • Excel Version 2016 (32bit)
    • IE 11

Do you think its Version of office or internet explorer ?

Thanks for your attention. I’m looking forward to your Suggestions.

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

6 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Andreas Killer 144K Reputation points Volunteer Moderator
    2020-12-04T11:39:50+00:00

    but once you Wait.Second or Application.Wait after the debugging it go through for few transactions and gettin Debug again. 

    Yes, I know. And when you have found a workaround for that, you went into the next problem.

    If you get a new environment you get new problems. It's like the Al Bundy song: "This I tell you brother, you can't have one without the other."

    And even if you solved all that, in the next moment the web site changes and everything starts all over again.

    It's your code and up to you to solve it, all that issues have nothing to do with Excel.

    Andreas.

    2 people found this answer helpful.
    0 comments