Excel Add-ins - GetObject err.number=-2147024895 
Author Message
 Excel Add-ins - GetObject err.number=-2147024895


I'm trying to modify an EXCEL file from an Access module
(Office 97).

If EXCEL is closed, the line
  Set My_Excel_Fich = GetObject("FichIn.xls")
produces the err.number -2147024895 (nowhere documented)

The reason behind it is that the EXCEL add-ins "Analysis
ToolPack" and "Analysis ToolPack-VBA" are installed. When
the procedure 'opens' the EXCEL file, it seems to try to
run code related with those add-ins and then it generates
the error above.

Have you ever had this problem? Did you manage to
circunvent it? How?


Wed, 03 Nov 2004 00:35:53 GMT  
 [ 1 post ] 

 Relevant Pages 

1. Getobject (,Excel.Application) without knowing its version number.

2. COM Add-Ins for Excel

3. GetObject err for InternetExplorer control

4. programmatic adding of add-ins

5. COM Add-INs, cannot restore a built-in Add-in

6. Add-ins not listing in add-in manager

7. How do I add a menu to the Add-Ins menu in Visual Basic 4.0

8. Add-Ins, How to add a Toolbar.Button

9. Running excel add-in (added into excel - not access) in Access VBA

10. Err.Number

11. use getObject to retrive excel file

12. GetObject("","InternetExplorer.Application") fails in Excel VBA


Powered by phpBB® Forum Software