Welcome to the SRP Forum! Please refer to the SRP Forum FAQ post if you have any questions regarding how the forum works.

NickStevenson

About

Username
NickStevenson
Joined
Visits
49
Last Active
Roles
Member

Comments

  • Hi Kevin Really appreciate your help! The SAVEAS is working perfectly, however I still get the dreaded 80020005 when printing, using: wdBackground$ = 0 oPrintOut = SRP_Com(oDocHandle, "CALL", "PRINTOUT", wdBackground$) If I remove the wdBackgrou…
  • Hi Kevin Here is some code cobbled together to illustrate the problem. Adjust the RUN VARIABLES to point to an existing WORD document, and choose whether to use native OI OLE or SRP_COM, and whether you want to just print the document or save as a …
  • Don, apologies, I can confirm that in OI9.4.4 SAVEAS to PDF worked using the native OLE functions, but SRP_COM fails with 80020005. I applied the latest SRP utilities as the version I was using was about 10 years old. I also tried SRP_COM with and …
  • Definitely worked with OpenInsight OLE in OI9. I'm going to try and fire up the old OI9 system and check with SRP_COM. I compared timings of SAVEAS (to PDF) and PRINTOUT (to Broadgun pdfMachine - 3rd party printer driver that prints to PDF) and foun…
  • Hi Kevin Tried that, got the same error 80020005. I checked the number of parameters and it is correct. This problem only arose in OI10 - with OI9 it worked perfectly. So it must be a 64 bit issue. Regards Nick
  • Don - see code below. Amend the initial run parameters to pick up your own Word doc (set up as mail merge doc), mail source doc (as in the Word doc), and the name of the file to save as. Then amend the var USEOIOLE to choose whether to use OI or SR…
  • Don - Good news - The ADODB connections are now working fine. The only problem I am left with (in both OI9 and OI10) is the call to SAVEAS2: wdFormatPDF$ = 17 ***oSaveAs = OleCallMethod(oDocHandle2, "SAVEAS2", pdfName, wdFormatPDF$) ;* original oSa…
  • Great, huge thank you! I'll update the system and let you know how it goes.
  • Don - one more thing. I'm testing the word automation conversion in OI9.4.4, the following two calls are not working, no OLE error is returned. Am I calling SRP_COM incorrectly? Both work fine in original OI OLE calls. *oSaveAs = OleCallMethod(oDoc…
  • Don - yes please, this is a mission critical item and without it we cannot complete the migration. Carl indicated we have missed OI10.2.1. I have commenced migrating all the OLE calls to SRP_COM in our word automation code, everything is going bette…
  • Good advice! You've probably guessed that I'm an OLE novice, would you by any chance have some sample code for a Word mail merge using SRP_COM that I can get some ideas from?
  • Don - my apologies for wasting everyone's time. Downloaded the latest version and hey presto it all works perfectly.
  • Don - May 2015. Hmmm. Should I download the latest version and try again?
  • Don - see code below. The first shows use of SRP_COM, the second shows revised code in OI OLE Comments in the first version indicate results of calls. Not sure what SRP version - but it would have been a few years ago. Is there a way to tell? Testin…
  • Recoded using the OI OLE functions, all well, no locks left behind. Thanks for your help.
  • Thanks Don. I've stepped through the code in the debugger n number of times, there are no other objects to be released. I'll take a look at the OLE functions as suggested.
  • Thanks for swift replies! SRP_Com is called as a subroutine, designed using your "Much ADO about nothing" sample code. The variable objConnection returns a numeric string, like 7148112. This is used in the final RELEASE call. We only use the connec…