| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
ADO Automation Error
I hate myself sometimes.
I found the problem - password protection. I removed it, and the code works like it should. "joel" wrote: Does the workbook have a "sheet2" (no dollar sign)? The dollar sign at the end of the sheet name is required using the ADO method because worksheets have a hidden dollar sign in the sheet name that you don't normnally see. -- joel ------------------------------------------------------------------------ joel's Profile: 229 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=180404 Microsoft Office Help . |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Run-time error '-2147221080 (800401a8)': Automation error | Excel Programming | |||
| Compile error: Automation error in Excel 97 | Excel Programming | |||
| Urgent!!! Run-time error '-2147024770 (8007007e)' Automation error | Excel Programming | |||
| Run-Time Error'-2147221080(800401a8)': Automation Error | Excel Programming | |||
| Unknown where is the problem on the Runtime error - Automation error | Excel Programming | |||
Threaded Mode
