>>The latest UTMag contains an article on Excel Automation....
>>
>>Regarding speed of running Excel Automation it states :
>>
>>"Make sure you have enough RAM, so that Windows doesn't need virtual memory to run both Visual FoxPro and Excel at the same time. "
>>
>>How much RAM is required to insure VFP and Excel can both run at the same time without requiring use of 'virtual memory'.
>>
>>Thanks,
>>Dave.
>
>I am really not sure about the exact amount - and the exact amount would, of course, depend on the OS, other open programs, the version of VFP and Excel, and perhaps a few other factors, too.
>
>However, I noted that with 16 MB, Excel Automation is much too slow, and with 64 it is fast enough. I assume - but I am not sure - that 16 MB would be less than the RAM used by VFP + Excel.
>
>32 MB might work reasonably, but I would recommend at least 64 MB. While any new computer nowadays comes with much more than that, the problem is, precisely, the older equipment with less RAM (and less speed, too) - like the machines of some of my users at Bata-Bolivia, which prompted me to write this particular comment.
>
>HTH, Hilmar.


thanks for the help...
i am wondering if a VFP SYS function reveals the amount of available memory to the OS?