NSD error when trying to access an Excel Spreadsheet from an embedded object on a Lotus Notes Form

I do not  get an NSD error, but the users do.  I have Lotus Notes 6.5 and the users have Lotus Notes 6.   The object is created with the below code and no one has a problem at this point.   The Excel spreadsheet(s) are created with headings and formulas.  

                Call uidoc.gotofield("Sheet")
     Set handle = uidoc.CreateObject("Audit","Excel.Sheet.8","")
     Set xl = handle.Application

The user enters their data and when selecting a button on the Lotus Notes form - that's when the user gets a NSD running.   I don't know where the NSD error is occuring, but this is how the object is being accessed.
     Set uidoc = workspace.CurrentDocument      
     Set doc=uidoc.document
     Set handle = uidoc.getobject("Audit")  
############################################################
### FATAL THREAD 1/6 [   EXCEL:05a8:  296]
### FP=0x0012fcb4, PC=0x3011bc8c, SP=0x0012f6ec, stksize=1480
### EAX=0x00000000, EBX=0x00000000, ECX=0x00000064, EDX=0x80000000
### ESI=0x008278b0, EDI=0x00000000, CS=0x0000001b, SS=0x00000023
### DS=0x00000023, ES=0x00000023, FS=0x0000003b, GS=0x00000000 Flags=0x00010246
Exception code: c0000005 (ACCESS_VIOLATION)
############################################################
Any help you can give me on this will be greatly appreciated.
SCIDevAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

qwaleteeCommented:
There's really not enough information here to begin debugging the problem.  It looks like the problem is ocuring in Excel, nt in Notes... and of course, if Notes is trying to execute the getObject for an Excel object, it would be using the Excel OLE Automation server.  NSD is a Dr. Watson replacement, so it can in fact report errors in other applications.

You don't state whether the second bit of code is executed while the object is already is use from the first bit of code, or whether the object has already been closed, and the user is pressing the button to start using the object once more.

You also don't state whether, after the NSD, Excel dies, Notes dies, or both.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
SCIDevAuthor Commented:
Thank you for responding.
At the end of the first part of the code I have :
xl.quit
xl.nothing
handle.nothing

Then the user opens the excel spreadsheet and enters data - doesn't close the spreadsheet and then selects a button on the form (this is the second part of the code) to take them to another part of the form.   Notes dies and maybe Excel - or maybe it may be just hanging - I can't get it to happen on my computer so I'm not really sure of how to debug this.  I try to duplicate everything that the user is doing but I still don't get any errors.    I will try to get one of the users to check their task manger to see if Excel really ends.   If it is the Excel OLE Automation server, how would I resolve the problem?  We did look at that before, but couldn't find enough information.  

0
HemanthaKumarCommented:
Apply recent patches to R6.5 and see if you can reproduce the same error again

~Hemanth
0
Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

Sjef BosmanGroupware ConsultantCommented:
I've seen suggestions of Excel (Office) reinstallation. For the rest, no clue whatsoever.

What's the exact version of the Notes client? R6.0.3 seems pretty stable.
0
qwaleteeCommented:
T debug the undebuggable, simplify.  Create a test versio of the form, and keep stripping out as much interaction with Excel as you can, until you find "the one thing" that if present, will cause a crash on the second activation, and if not present, won't crash it.

Sometimes, it pays to save, close, and re-open your document before a second actication (or even immediately after finishing with the first one, if possible).
0
SCIDevAuthor Commented:
Thanks for your suggestions!   We did try reinstalling Office a while back.  The users are on a different version of Notes then I am - so we are  trying to get that changed.  I will try to get one of the users to work with me on what you suggested qwaletee.
0
qwaleteeCommented:
SCIDev,

Looking to hear how you made out.

- qwaletee
0
SCIDevAuthor Commented:
Well - I'm still struggling with this application, but at least  because of what you said I was able to search on a Microsoft site & get a sample that I used and I'm no longer getting an NSD error. Thanks again!  
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Lotus IBM

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.