Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Detect more info when workbook does not ack right.
if the message is from an alert, then probably not. (or maybe you could
with extensive work in the Windows API, but I wouldn't know how to do that). If it is from an error message, then you can trap the error and record the error information using the error object. Regards, Tom Ogilvy "Tod" wrote in message ... This is more of a scripting question, but I thought I'd start here first. I have several scheduled tasks. Each runs a vbscript. Each script opens a workbook and runs a procedure in that workbook that gets data from an Access database and updates a sheet in the workbook then closes everything and destroys the objects. The script ends by adding a line to a text file that tells me the process ran and what day and time. Ultimately I'd like to compile all of these scripts into just one vb application, but as of today that's how I do it. Anyway. most of the time this all works fine. However there are a couple of problems, and they seem related. Sometimes I come in the next day and open one of the workbooks that gets updated overnight and it tells me that I already have the workbook open. But I don't. Something must have happened during the script running. I just wish it could tell me more about where the problem was encoutered. There is where my question comes in. Is there a way I can have Excel notify my script if it is having problems and have the script close everything down naturally. Then I'll either know what was causing the problem, or could avoid it all together. Any thoughts? tod |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Returning info from another workbook | Excel Discussion (Misc queries) | |||
copying info from one workbook to another one | Excel Worksheet Functions | |||
Certain info from one workbook to another | Excel Worksheet Functions | |||
How do I set up a workbook that the worksheets update info | Excel Worksheet Functions | |||
How do you find info in a workbook? | Excel Discussion (Misc queries) |