Re: Program hang after generate a couple of PivotTable workbook in

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Since we haven't seen your code, we'll have to ask all the stupid questions
I guess.

You're not calling CREATEOBJECT("excel.application") each time are you? If
you are, are you telling it to .Quit() each time around?

You *may* be leaving behind an instance of Excel each time, consuming
machine resources, and eventually Windows is just giving up because you've
used up everything it can give you.

Dan

Kam wrote:
I did. but I don't know why it stop during the reading or complete the
reading of the data.

"Carsten Bonde" wrote:

Kam,

i only have less experience with Excel-automation. It sounds like
Excel has a problem, not Vfp. Have you tried to save in Excel after
each table-creation? Maybe close Excel and reopen the spread***
for each salesman.

I hope you will find a solution.

--
Cheers
Carsten
_______________________________

"Kam" <Kam@xxxxxxxxxxxxxxxxxxxxxxxxx> schrieb im Newsbeitrag
news:46704428-9F58-4D3D-8197-1235EDD501F8@xxxxxxxxxxxxxxxx
I am using OLE automation in VFP to generate the PivotTable
reports, one for
each salesman.

The code work fine, when generate a single workbook, with a couple
of PivotTable reports.

Then I create a table and use a do while loop to generate the
reports for every salesman. but after generate a couple of
workbook, the program and excel hang.
The cpu utilization is close to zero.

when I kill the excel, all error come up "OLE error code
ox800706be; the remote procedure call failed.
the code always stop at
oPivotCache.CreatePivotTable(oTargetRange,"PivotTable")


In excel, it look like either complete reading the data from the
data source, or in the middle of reading the data from the data
source.

but everytime when I finish generated the workbook I release all
memory and
object in the program.

Can anyone help?


.

Quantcast