| || |
Post Processing with VBA Resource Strain
I have created an aging report using vba in excel. It takes all defects created in a parameter Date Range for: New, Closed and Open. I exported the data from QC and tested. I then cleaned up the code as much as I know how. But, when I put the code in QC Post Processing, it is locking up my system and I see that 95-100% resources are being utilized. Can't think of what else to do. I tried searching the web, QC Forum and nothing seems to fit.
Anyone have any suggestions?
Re: Post Processing with VBA Resource Strain
Strange, but hard to say without having the code. I would try to eliminate even more code, e.g. by putting it in a VBA comment. Maybe this is the only way to locate the line that is causing the problem.