Automation Error, Unknown Error. Error value - 440

N

Neo

I wrote a program to do some data extraction and charting using VBA, i use common dialog control to get "Showsave" and "Showopen" to help the user to browse and open and save the desired file. I used MS office 2000 to make this. This works perfect in PC's with Office 2000 and 2003. But it gave the following error- "Automation Error, Unknown Error" when tried on office XP. i checked the macro security level which is set to low. and some of my other excel programs using macros are working well in this PC, except this program. the error value was 440

Pls help on thi

Neo
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop down list control value in vba 2
Excel Macro error 5
Run Time Error '1004' General ODBC Error 6
Automation Error with IE 8 in Access 2007 2
Excel 2007 -- Automation Error 14
Outlook 2003 error 0
Excel automation in ASP.NET, error 0x800A9C68 0
Error 5852. Datasource is missing when automated. 1

Top