Run VBA code in 64-bit version

Question

Dear all,

I'm running a VBA macro after an Office upgrade and I'm finding the problem described in this link (the error is exactly the same):

https://docs.microsoft.com/en-us/previous-versions/office/troubleshoot/office-developer/compile-error-editing-vba-macro

Here is the suggested solution: 

To resolve this issue, ignore the "Compile error" and run the VBA code in the 64-bit version of the Office 2010 program.

Please, could you tell me how can I choose the 64-bit version when I'm running the VBA code? Which are the steps to follow?

Thank you very much.

Elena

Answer 1

Ciao Elena,

I'm running a VBA macro after an Office upgrade and I'm finding the problem described in this link (the error is exactly the same):

https://docs.microsoft.com/en-us/previous-versions/office/troubleshoot/office-developer/compile-error-editing-vba-macro

Here is the suggested solution: 

To resolve this issue, ignore the "Compile error" and run the VBA code in the 64-bit version of the Office 2010 program.

Please, could you tell me how can I choose the 64-bit version when I'm running the VBA code? Which are the steps to follow?

Non è possibile scegliere di utilizzare la versione a 64 bit di Excel; puoi usare solo la versione che hai acquistato.

Ti chiederei di confermare la versione di Excel che hai acquistato e di pubblicare il codice problematico.

===

Regards,

Norman

Answer 2

Buonasera Elena,

Essendo un sito ITALIANO sarebbe segno di educazione, scrivere in italiano. Non tutti sono tenuti a sapere l'inglese, magari tradotto con qualche programma di traduzione...

Saluti

Enxo