Max Wanadoo
max.wanadoo at gmail.com
Thu Nov 12 08:08:30 CST 2009
Hi List, I have a word document which has properties populated from an Access record. The document opens ok, but there are no menu options shown, no file options, no print options, etc. Just blank borders. The code I suspect is the problem is this bit, but I have put the full code below in case anybody can see any other problem. It may be the wdWindowStateNormal which is wrong. With appWord .ActiveDocument.SaveAs strSaveNamePath .ActiveWindow.WindowState = wdWindowStateNormal .Visible = True .Activate End With Can anybody throw any light on this? Thanks Max 'Get template path from Word Options dialog Set appWord = GetObject(, "Word.Application") 'Create a new document from template and set doc property values Set doc = appWord.Documents.Add(strPathTemplatesServer) With appWord.ActiveDocument.Bookmarks .Item("TID").Range.Text = "TID/" & CStr(lngOrgID) .Item("Date").Range.Text = CStr(Format(Date, "d mmmm yyyy")) .Item("Addr").Range.Text = Trim(strAddr) .Item("Salutation").Range.Text = Trim(strSalutation) End With 'Save document and make it visible Dim intCount As Integer, bSaveNameFail As Boolean intCount = 1 bSaveNameFail = True strDocsPath = "\\server\Z\OrgLetters\" strSearchName = "" Do While bSaveNameFail strSaveName = modGetSaveName(intCount, strSearchName, lngOrgID) strSaveNamePath = strDocsPath & strSaveName strTestFile = Nz(Dir(strSaveNamePath)) If strTestFile = strSaveName Then ' already have this name on disk, create a new name bSaveNameFail = True: intCount = intCount + 1 Else bSaveNameFail = False End If Loop ' record the letter being sent Call modLettersSent(strSaveNamePath, "frmTrustsShortLetters", , lngOrgID) With appWord .ActiveDocument.SaveAs strSaveNamePath .ActiveWindow.WindowState = wdWindowStateNormal .Visible = True .Activate End With