Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 442
  • Last Modified:

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.
0
SCIDev
Asked:
SCIDev
1 Solution
 
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
 
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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now