I recently install Sage 2023 with update 3 on a W2022 Standard server.  The client insisted on office 365 64 bit.  I was OK with that as Sage said Sage 300 was compatible with 64 bit excel.

I was able to get the Financial reporter running but the Sage macros would not run. the VBA would not initiate or even give an error message when attempting to run any macro. Sage intelligence also did not run correctly and would not initiate  running a report.

As a test we uninstalled the 64 bit Office and installed 32 bit office and everything ran correctly.  This tells me that Sage 300 is NOT compatible with 64 bit office.  It will not allow any out of the box macros run or any customer macros.

I would thing that the macros need to be updated to be 64 bit macros or the vba installed needs to be 64 bit with the Sage operating system.

Any suggestions on how I can get the macros to run in 64 bit Office 365 environment??

JB

I recently install Sage 2023 with update 3 on a W2022 Standard server.  The client insisted on office 365 64 bit.  I was OK with that as Sage said Sage 300 was compatible with 64 bit excel.

I was able to get the Financial reporter running but the Sage macros would not run. the VBA would not initiate or even give an error message when attempting to run any macro. Sage intelligence also did not run correctly and would not initiate  running a report.

As a test we uninstalled the 64 bit Office and installed 32 bit office and everything ran correctly.  This tells me that Sage 300 is NOT compatible with 64 bit office.  It will not allow any out of the box macros run or any customer macros.

I would thing that the macros need to be updated to be 64 bit macros or the vba installed needs to be 64 bit with the Sage operating system.

Any suggestions on how I can get the macros to run in 64 bit Office 365 environment??

JB

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