I am putting this is multiple Forums (development and admin) so, please bare with me.
We have a process currently running in production today. Scheduled agent (LotusScript) that runs on server (Win 2003) to generate PDF (via PDFCreator), then runs Word 2007 to create a table of contents and then ports it all over to Adobe in .pdf format. Works great and has been for years.
Now, we are in the process of upgrading all of our servers to Windows 2012 64 bit, Notes 9 32 bit and Office 2013 32 bit. During testing, we are noticing that the Word portion of the code is no longer working. The code does load Word 2013 (viewed through Task Manager on server) but, we can’t seem to get a handle on it to perform the rest of the functionality. We have added in extra code to test for Null or Nothing and still runs the exact same, as if it does recognize Word but, does nothing.
Testing new piece of code locally, Word 2013 does load up on the screen. Moving that exact code over to the new server, Word 2013 does load in task manager BUT never loads on the screen. Also, the rest of the code does NOT run. This code is a simple TypeText that just adds text to the blank document. In fact, here is the test code that works locally (laptop) but NOT on server. By not work I mean there are no errors or anything being thrown. It runs, loads up Word 2013 (as viewed in Task manager) but does not add text to document or save it:
Sub Initialize
Dim msWord As Variant
Dim msDoc As Variant
Dim msText As Variant
On Error Resume Next
Print “Loading Microsoft Word…Please Wait…”
Set msWord = GetObject(“”, “Word.Application”)
If msWord Is Nothing Then
Set msWord = CreateObject(“Word.Application”)
End If
Print “Microsoft Word Loaded”
msWord.Visible = True
Print “Microsoft Word Visible”
msWord.documents.Add
Print “Microsoft Word added new blank document”
msWord.Selection.TypeText(“and you know my name is Simon…”)
Print “Microsoft Word added text”
Dim msFileName As String
msFileName = “C:\temp\JasonCyr.doc”
msWord.ActiveDocument.SaveAs2 msFileName$
Print “Microsoft Word saved new document”
Print “Loading complete”
End Sub
My questions are, is anyone else doing anything similar to this and does it work for you? Also, is there perhaps some setting (windows server, word, notes 9, security even) that we are missing? Finally, does anyone know what logs are out there on the server to help us troubleshoot Word 2013 in case that is throwing an error in backend and we just don’t see it up front?
Any help would be greatly appreciated.