what is the maximum amount of memory Excel will allow me to allocate in a
Dll. I have been able to allocate up to 512MB but some machines wont allow
more than 228MB. What is controlling this max. I have played with pagefile
settings with limited success.

My Dll is written in C++ using ATL with several automation interfaces.