Powerpoint automation problem

[stiko]

Hi,

i use MS Office 2000 SP-3 and Visual Basic 6.0 to generate
Powerpoint slides automatically. The code can be executed
by selecting some options in an Access form and click on a
command button.

The problem is that if i would like to generate a lot of
slides (cca. 50) the generator slows down dramatically
(filling a cell takes 10 seconds). The task manager's
performance says that the memory usage is 50 percent but
the CPU usage is a constant 100 percent.

Thank you very much for your help in advance.

 

[Mike M.]

Do you have PowerPoint visible while you are automating it? If so, try
without making the window visible. That might increase the efficiency.

 

[stiko]

Thanks for the answer, but unfortunately it does not help.

I've followed the memory usage by task manager and found
that this phenomena occurs after the memory usage of
Powerpoint reaches 95 MBs (Why is it so high and do
constantly grow into the sky? If the VB program reserve
too much memory, i should see it in the ACCESS.EXE process
and not POWE.....EXE...)

Still waiting for your help.

 

[Mike M.]

Who don't you post the relevant peices of code. Someone might be able to
see something. I do something similar with C++ and don't notice a problem.