Page 1 of 1
Error in ADI for entering Journal description
Posted: Tue Nov 11, 2008 10:06 am
by pkjain_try
Hi,
We are using ADI to upload Journals in to GL system. I am getting an below error when i enabled the Journal description to be uploaded along with the Segments, Debit and Credit and i couldnt save the settings.
An Unexpected Error Has Occurred in ADI:
Routine: MAINGLDI: Do Template
Source: Microsoft Office Excel
Message: Add method of Sheets class failed
Error Number: 1004
It is recommended that you run the Diagnostic Wizard to verify that ADI is correctly installed.
Can Anyone help me to fix the same
Regards
PK
Posted: Fri Nov 28, 2008 6:24 pm
by mudunuribhaskar
Hi ,
Whether theproblem solved?
Otherwise, use the metalink Doc ID: 1058069.6
Regards,
Bhaskar Mudunuri.
Posted: Mon Feb 09, 2009 9:13 am
by bethany12
Hi did you ever get a solution for this problem? I have got exactly the same error....
Many Thanks
Beth
[:(!]
]Hi,
We are using ADI to upload Journals in to GL system. I am getting an below error when i enabled the Journal description to be uploaded along with the Segments, Debit and Credit and i couldnt save the settings.
An Unexpected Error Has Occurred in ADI:
Routine: MAINGLDI: Do Template
Source: Microsoft Office Excel
Message: Add method of Sheets class failed
Error Number: 1004
It is recommended that you run the Diagnostic Wizard to verify that ADI is correctly installed.
Can Anyone help me to fix the same
Regards
PK
<i><div align="right">Originally posted by pkjain_try
Posted: Mon Feb 09, 2009 10:21 am
by admin
If you are adding description manually as a column then it will give error. You should add more columns by selecting columns. Thanks
Posted: Mon Feb 09, 2009 11:14 am
by bethany12
I'm not sure what this reply means, it does not solve the error 1004 issue with ADI...?
]If you are adding description manually as a column then it will give error. You should add more columns by selecting columns. Thanks
Thanks
Beth
Posted: Mon Feb 09, 2009 12:26 pm
by admin
What is the version of ADI? As I remember there were couple of patches need to be applied after installation of ADI. Thanks
Posted: Thu Aug 20, 2009 7:42 am
by utsavwalia
Nothing to do with ADI, its with VB.
Posted: Thu Aug 20, 2009 9:31 am
by admin
Pl let us know the following,
- How you are adding description column?
- Any other upload is working?
- Is this the only PC where you have tried ADI?
- Version of Office?
Tks
Posted: Thu Jul 14, 2011 2:42 am
by Brodieb
Excel 2003, Navigate to Tools -> Macro -> Security -> Trusted Publishers. At the bottom of this security box there is an option ?Trust access to Visual Basic Project? make sure that this is checked and then click on ok. Close Excel and then try again and this solves the problem.
In 2007, it's under excel options under the ribbon, then trust centre, trust centre settings, tick the Trust acecss to the VBA project object model.