Insufficient system resources

[somebody]

I’m getting an error message that says that my network drives are not accessible. “Insufficient system resources exist to complete the request.”

I am running a macro in excel that takes a large amount of data and runs a loop witch filters the data by unit number, copies the filter area, pasts the filtered data into another work book, names the new work book accordingly, saves it onto a network drive, and closes the newly created work book.

I was told that at one time it did work however, now every time it reaches 84 to 87 units the macro stops because I am denied access to my network drives and can’t save the created work book.

Running the macro doesn’t just not allow me to save anything to the network drives but denies me access my network drives. In order to access those drives I have to restart my computer.

I have moved everything onto my hard drive, including the macro, the data, and changed the path where it will be saved so that the network drives are not even touched, but the macro still shuts down the network drives. It happened at the same place at around 84 to 87 units for which every unit it opens up a new work book.

One of the things that might be stopping the macro is if Excel has some limitation to how many work books it can be opened in a session. Does anybody know if this limitation in the number of workbooks or worksheets exists? I am also looking for other suggestions on how to debug this macro or possible solutions.

 

[AlphaFrog]

What version of Excel do you have?
Excel 2003 specifications and limits
Excel 2007 specifications and limits

Does your macro Create\Save\Close each workbook one a at a time and then moves on to the next? Or does it Create all, Save all, then Close All?

 

[somebody]

I have office 2007 and it creates, saves, and closes one at a time, however I still see the default tittle increasing and it never goes past about 87.

 

[AlphaFrog]

Can you post the code for your macro?