Macro created in 32-bit not working in 64-bit system

Hi Everyone,

I am in need of a favour. Recently we migrated our office system to 64-bit. We have bunch of VBA macros that were created in 32-bit system. After our migration, I tried to run them. Initially I was getting issue in declaring function and after using Ptrsafe it got resolved.

Now the real issue occurs in coding. I have declared two variables here. one for Mainframe and other for webscreen -

Please Login or Register  to view this content.

I am taking mainframe session name from the excel cell.

Please Login or Register  to view this content.

as soon as control enters the above line, its throwing "Run-Time error '429': ActiveX Component Can't Create Object"

I tried checking references and all seems to be ticked. I am helpless here.
Could you please help me in resolving this issue. Please let me know if you need any more details. Thank you very much in advance.

Originally Posted by xlnitwit

It sounds like you are using a dll that is not compatible with 64bit Office. You will need to try and get a 64bit version from the supplier.

Thank you. so I will give a try to install MS office for 64-bit version and try again.

Yes. you are right. MS office is 64-bit. I got what you are saying. I am trying to find which reference maps to AutSess & Webscreen

The issue you are running into with 3rd party DLL compatibility has been the only reason I have not migrated to 64 bit office, it's a shame

I tried all possible solutions. There was no missing reference. reinstalled MS office. But no luck. So I have downgraded MS office from 64bit package to 32bit package. And everything back to normal after that. So as of now its the only possible way to run the macros

have a look at this

https://www.jkp-ads.com/articles/apideclarations.asp

https://stackoverflow.com/questions/...64-bit-windows