"Ron Rosenfeld" wrote in message

When VBA Application.OperatingSystem runs on a 64-bit system, it will
report a 32-bit system <sigh. This has been the case for years,
and I don't know if it has been corrected in Office 2010 or in 64-bit
versions of Office.

You can tell if you are running Office 64-bit with the newly added Win64
conditional constant introduced in 2010's VBA7

#If WIN64 = true then
' code for 64 bit Office
#Else
' 32bit code
#End If

That's important as will need to cater differently for most APIs and other
stuff, but only if the code might be run in multiple versions.

Regards,
Peter T