VB cannot open/read data from excel file anymore - automation error 
Author Message
 VB cannot open/read data from excel file anymore - automation error

Other programs can not open excel files anymore (office 97 and NT)  like

by douple clicking attached excel file in word document. Visual Basic
programs gives Error message "Run time Error '-2147024895 (80070001)
Automation Error, incorrect function" while trying read data from excel
(by using Excel Object libraries, I quess).

BUT if excel is open/runnig already everything works fine.

Do anybody have any idea how to  fix this feature? It's actually second
NT which started to act like this. In this morgning everything works ok
but now none of the programs trying to launch excel document don't work
anymore without that trick to start excel program before hand.

Jukka



Fri, 20 Aug 2004 00:50:48 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Error 64509: Cannot open anymore databases

2. error in a sheet, excel project doesn't open anymore

3. ERROR -214741785 Automation Error Excel open

4. How to open and read data in Excel from VB.

5. Reading Excel files without opening excel

6. Error trying to read calendar data using VB.NET when Outlook is not open

7. HELP! OLE error- Cannot Open Excel

8. Help! OLE Error- Cannot open Excel

9. Cannot Open my *.mdb file (it says error 3015 Indexes - but I think corrupted file)

10. Reading data from Excel file to VB

11. Cannot run ASP pages anymore - COM+ and ASP error

12. Clear Excel data using VB Script - File Already Open

 

 
Powered by phpBB® Forum Software