-->

Tuesday, January 27, 2009

Custom Search Engine to Search All Dynamics GP Blogs

Often I like to go back and refer to a blog post I read some time back. Earlier it used to be simple(It used to be Mark Polino or Mariano Gomez), but now with the GP Blog explosion, I have to patiently review the feeds one by one ....

To help myself, and other people like me I have setup a Custom Search Engine which searches all Dynamics GP Blogs. I took the list (about 20 Blogs) compiled by Dave.

You can use the search engine from the top right box on www.jivtesh.com,

or directly from this URL - http://www.google.com/coop/cse?cx=008280271627227523833:qcy2cm12dam

FYI - You can also add it to your Blog/Website by following the instructions here - http://www.gmodules.com/ig/creator?hl=en&url=http%3A%2F%2Fwww.google.com%2Fcoop%2Fapi%2F008280271627227523833%2Fcse%2Fqcy2cm12dam%2Fgadget

Tuesday, January 6, 2009

Unhandled Object Exception While Importing a Budget from Excel

While trying to import a budget from Excel in GP 10 we got this error -

Unhandled Object Exception

Unable to access field ‘Workbooks’

Exception Class Object Exception

Followed by the message –

You must have excel installed on this machine in order to run this application.

Excel was definitely installed. The excel sheet was closed. I looked around in newsgroups and knowledgebase but did not find anything useful. Our in house GP expert Rubal told me to look into the task manager to check if there was an instance of Excel in there. Sure it was. I ended that instance and the error went away.

Surprisingly I have seen this error twice in two weeks with two different customers, so I thought of putting it out here in case one of you found it useful.

The original Error

clip_image002

Followed by the message - You must have excel installed on this machine in order to run this application.

clip_image004

End the Extra Excel Process in Task Manager

clip_image006