automation error 
Author Message
 automation error

I know I'm doing something wrong here....but I'm trying to open an excel
worksheet and launch a macro with the following code and I'm getting an
automation error:

dim excelsheet as object

set excelsheet = getobject("//server/directory/excelsheet.xls")
columns("A:A").select

Any ideas or suggestions?

Douglas



Sat, 04 Aug 2001 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Compile error: Automation error, Error 32811: Unexpected error

2. Automation Error during Remote Procedure Call (RPC) using DCOM and Automation Manager

3. Compilation error: Automation Error (Error 440)

4. Run-time error '-2147417846 (8001010a)': Automation error (error 440)

5. Run-time error '-2147417846 (8001010a)': Automation error (error 440)

6. Compilation error/Automation error

7. Compile error: Automation error

8. Automation error (Error 440)

9. Error: Automation Error and other problems

10. Compile Error : Automation Error

11. Automation error... Error 424, Object Required

12. Receive Error (404) Automation Error when creating new mailitem from MS Access

 

 
Powered by phpBB® Forum Software