Running VBA code created in 32 bit excel on Windows 10 64 bit

Dear Colleagues,
Hope you are doing,

Running VBA code created in 32bit excel version 2016, meanwhile I moved to 64bit windows version but excel version is 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, also I tied to add DoEvent & Application.wait, but sometimes it’s working and sometimes is not. More information below:
Old Laptop: Windows 7 (32bit) - Excel Version 2016 (32bit)
New Laptop: Windows 10 (64bit) - Excel Version 2016 (32bit)

I’m aware that it’s taking the .DLL from WOW64, but even though it’s should work fine ? Or shall I insert Declare PtrSafe & LongPtr if I’m using 64bit environment.

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

Apologize I can’t share VBAcodes because it’s an internal project.

Originally Posted by rorya

You only need to amend API calls if you are running 64bit Office as well. Not sure what you mean about running VBA in IE though?

Errors 13 and 91 suggest a code problem that is nothing to do with the version of Office.

Hello rorya, Thank you, so no need for API if I’m running 32bit office on 64bit windows ?

I mean IE = Internet Explorer. Yes indeed error 13 and 91 is nothing, but I’m running the same in the 32bit windows without those error.
I tried something like wait/loop but sometimes it works sometimes not.

I disabled the debugging from IE, and I got debugging but after I added Application.Wait DateAdd("s", 1, Now) in the VBA script - It goes through but somehow it stoped in some point but once click resume it works.