Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error 1004 help needed
I'm very close to having this fixed. I need a little bit of help on the last
part. I have a file on a loop that opens another file, does a bunch of stuff, then closes the other file. Then everything repeats. This runs 24 hours a day and goes for days and days and works fine, then for no reason it gives: method open of objects workbooks failed. All I can find is that this error means the file I'm trying to open is corrupted, but I know this is not the case because the file that is opening a closing again and again is not being saved, so there are no changes. Additionally, to get things going agian, I just end the debugger and open the first file again. That's it. But I want this to happen on it's own. All I need is an error handling code that will do this for me. One option that would solve my problem would be two steps. On error: 1) Excel exists completely without saving changes on any open files. 2) Workbook Star1 opens |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
run time error 1004 general odbc error excel 2003 vba | Excel Programming | |||
Run Time 1004 Error: Application or Object Difine Error | Excel Programming | |||
Paste-Special - R/T 1004 help needed | Excel Programming | |||
run-time error '1004': Application-defined or object-deifined error | Excel Programming | |||
Help needed with Run Time Error 1004 | Excel Discussion (Misc queries) |