Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete "count" of workbooks?
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple "source" workbooks linked to single "destination" workboo | Excel Worksheet Functions | |||
problem with Linking workbooks via "copy" and "paste link" | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
use variable in Workbooks("book1").Worksheets("sheet1").Range("a1" | Excel Programming | |||
"Subscript out of range" error for: Workbooks("Test1.xls").Save | Excel Programming |