M
miao jie
right now I'm write a function with VBA in Excel which open a big data array
in memory. it takes around 20 minutes. This is OK and no problem.
But when I run it on my pc it is not possible to do something else (email,
internet, …) as soon as I start another program then this function comes in a
deadlock. XLS file does not respond anymore and I have to kill the process.
Even when the screensaver pops up the program does not continue anymore.
That means we only can run the program on a dedicated PC without an active
Screensaver.
I do not know that we can avoid this. Does anyone know a solution? thanks in
advance!
in memory. it takes around 20 minutes. This is OK and no problem.
But when I run it on my pc it is not possible to do something else (email,
internet, …) as soon as I start another program then this function comes in a
deadlock. XLS file does not respond anymore and I have to kill the process.
Even when the screensaver pops up the program does not continue anymore.
That means we only can run the program on a dedicated PC without an active
Screensaver.
I do not know that we can avoid this. Does anyone know a solution? thanks in
advance!