Delete "count" of workbooks?

's Computer Specifications

Hi All.......

I have a program that attempts to send out about 300 emails automatically.
It appears to work fine as it takes a picture of a range and pastes it into a
new workbook, sends the email with that new workbook as an attachment,
deletes that workbook and steps on. I notice as it's running tho that the
"number" of the new workbook it opens each time, increments up by one...ie
Book1, Book2, etc.......then, the trouble. Each time it gets up to Book30,
even tho no other workbooks are open except my Main one and Book30, the
program freezes and "will not paste to the new workbook"......am I running up
against some kind of an unalterable limit here, or is there some code that
will "reset" this BookNumber and get me past this point?

TIA
Vaya con Dios,
Chuck, CABGx3

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Multiple "source" workbooks linked to single "destination" workboo	=?Utf-8?B?REFWRUpBWQ==?=	Microsoft Excel Worksheet Functions	1	17th Sep 2007 05:33 PM
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next	BCB	Microsoft Excel New Users	7	13th May 2006 10:02 PM
Possible to change default "All Open Workbooks" to "This Workbook" in macro dialogue box?	StargateFanFromWork	Microsoft Excel Discussion	0	4th Jan 2006 10:49 PM
use variable in Workbooks("book1").Worksheets("sheet1").Range("a1"	=?Utf-8?B?THVj?=	Microsoft Excel Programming	2	28th Sep 2005 08:37 PM
"Subscript out of range" error for: Workbooks("Test1.xls").Save	=?Utf-8?B?SnVzdDEyMzQxMjM0?=	Microsoft Excel Programming	2	17th Jun 2005 03:16 PM