I recently had insufficient memory notification from Excel and decided to replace 32 bit office with 64-bit. Used the MS checking program to see if my excel files were 64-bit compatible and they were, with exception of 1 old unused file. Subsequent installation of 64-bit version worked well with my preferences/addins retained but many of my files gave catastrophic error on opening. On internet I see references to incompatibility of Active X buttons etc between 32 and 64 bit versions and think this is the cause - I use these. I also see some recommendations for programming these for both versions but that is a poor work-around. Is there anywhere where there is a clear explanation of what is and what is not compatible between versions. Otherwise I see Office 64-bit as being basically incompatible with most of the world.
Hi Trevor,
Just a thought:
You should write a code (in the 32 bit version, to avoid crashes) to replace all those active x buttons with shapes, you can detect the existing button position and size, even what macro is called from that button.
You can pass the old button details to the new shape then remove the old one:
Dim shp As Shape
Set shp = ActiveSheet.Shapes.AddShape(msoShapeRoundedRectangle, _
ActiveSheet.Cells(3, "B").Left, _
ActiveSheet.Cells(3, "B").Top, _
ActiveSheet.Cells(3, "B").Width, _
ActiveSheet.Cells(3, "B").Height) 'set size using a cell, or the existing button size
shp.TextFrame2.TextRange.Characters.Text = "DisplayedButtonText"
shp.OnAction = "MacroNameHere"
I use 64 bit too, had to update some api functions declarations, but works better than 32.
Thank you so much Catalin!
That looks do-able.
Having reinstalled 32 bit I have got over mem warnings and all works. Nonetheless, I would prefer to work with 64 bit as that's the future...Technically better etc. Will be trying your recommendation out in due course.
