Error in ADI for entering Journal description
-
- Posts: 4
- Joined: Tue Jul 08, 2008 7:02 am
- Location: India
Error in ADI for entering Journal description
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
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
-
- Posts: 4
- Joined: Fri May 19, 2006 8:00 am
- Location: India
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
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
-
- Posts: 8
- Joined: Mon Dec 11, 2006 7:38 am
- Location: India
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.
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.
Who is online
Users browsing this forum: No registered users and 12 guests