Office 64-bit Integration & Support?

Question

What's the latest word on Sage 300 and Office integration? Today we are running Sage 300 2018 and we are currently limited to Office 2019 32-bit. We are upgrading to Sage 300 2021 this spring but it doesn't appear that Sage 300 2021 supports 64-bit Office. Is that right? 
 Has there been any discussion about supporting 64-bit Office? or any options for those companies that don't have a choice due to other requirements in their infrastructure? Maybe workarounds or optional configurations? 
 Finally, is Office 365 supported? We dont use that flavor of Office, but are looking at possibly going that route...

Jay Converse Acumen · Answer

My old comments haven't aged well, because I know now that macros will run on 64-bit, we just converted our Acumen tools to run on either 32 or 64 bit. What doesn't work in 64-bit is data source controls on forms, so our nice finder forms got broken. We just replaced them with regular VBA list boxes. We use this to tell what version we're running: 
 Function Is64bitVba() As Boolean Dim sProdCode As String, vProdCode As Variant, sBitCode As String, sBitness As String sProdCode = Application.ProductCode vProdCode = Split(sProdCode, "-") sBitCode = Left$(vProdCode(UBound(vProdCode) - 1), 1) Is64bitVba = sBitCode = "1" End Function

Sage 300

Office 64-bit Integration & Support?

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING