Solved

Create watermark in word with vba from access

Posted on 2008-10-09
2
773 Views
Last Modified: 2012-08-13
I have an access database that is pushing a lot of information into a word doc using bookmarks in the word doc.  The last thing i need to do is insert a watermark into the document if a condition exists.  The conditional part is easy, what i am having problems with is just inserting the watermark.  I can record the macro and have that work from within word but i want to run it all from access with no macro in the word doc.  I'm sure its getting lost somewhere in the activedocument. lines but I am just beating my head against a wall at this point. The watermark ideally is angled text that will repeat on all pages. Thanks

with doc.
          ' Populating word doc
end with
0
Comment
Question by:rkremser
2 Comments
 
LVL 17

Assisted Solution

by:wobbled
wobbled earned 50 total points
ID: 22679252
I have almost got this to work - but I get an error on the line:

Selection.HeaderFooter.Shapes("PowerPlusWaterMarkObject1").Select

If anyone else can see what is causing this then please help out
Sub WordDocFromExcel()
' to test this code, paste it into an Excel module add a reference to the Word-library
' create a new folder named C:\Foldername or edit the filnames in the code
 
Dim wrdApp As Word.Application
Dim wrdDoc As Word.Document
Dim wrdWin As Object
Dim i As Integer
 
    Set wrdApp = CreateObject("Word.Application")
    wrdApp.Visible = True
    Set wrdDoc = wrdApp.Documents.Add ' create a new document
    Set wrdWin = wrdApp.ActiveWindow
    ' or
    'Set wrdDoc = wrdApp.Documents.Open("C:\Foldername\Filename.doc")
    ' open an existing document
    ' example word operations
    With wrdDoc
        For i = 1 To 100
            .Content.InsertAfter "Here is a example test line #" & i
            .Content.InsertParagraphAfter
        Next i
        
        wrdDoc.Sections(1).Range.Select
        wrdWin.ActivePane.View.SeekView = wdSeekCurrentPageHeader
        
        Selection.HeaderFooter.Shapes("PowerPlusWaterMarkObject1").Select
        
        With Selection.ShapeRange
            .TextEffect.Text = "ASAP"
            .TextEffect.FontSize = 1
            .TextEffect.FontName = "Times New Roman"
            .Line.Visible = False
            .Fill.Visible = True
            .Fill.Solid
            .Fill.ForeColor.RGB = RGB(192, 192, 192)
            .Fill.Transparency = 0.5
            .Rotation = 315
            .LockAspectRatio = True
            .Height = CentimetersToPoints(6.88)
            .Width = CentimetersToPoints(13.77)
            .WrapFormat.AllowOverlap = True
            .WrapFormat.Side = wdWrapNone
            .WrapFormat.Type = 3
            .RelativeHorizontalPosition = _
                wdRelativeVerticalPositionMargin
            .RelativeVerticalPosition = _
                wdRelativeVerticalPositionMargin
            .Left = wdShapeCenter
            .Top = wdShapeCenter
        End With
            wrdWin.ActivePane.View.SeekView = wdSeekMainDocument
        
        If Dir("C:\Foldername\MyNewWordDoc.doc") <> "" Then
            Kill "C:\Foldername\MyNewWordDoc.doc"
        End If
        .SaveAs ("C:\Foldername\MyNewWordDoc.doc")
        .Close ' close the document
    End With
    
    wrdApp.Quit ' close the Word application
    
    Set wrdDoc = Nothing
    Set wrdApp = Nothing
    Set wrdWin = Nothing
End Sub

Open in new window

0
 
LVL 6

Accepted Solution

by:
zipa72 earned 75 total points
ID: 22679555
rkremser,

I've created a sample how to create new Word document from Access, insert picture into header of that document, change properties for watermark, change position of the picture, close the document and dispose of objects (don't forget to do that!)

HTH

B.
Sub test()
  Dim ap As New Word.Application
  Dim doc As Word.Document
 
  ' create new word document
  Set doc = ap.Documents.Add(, , , Visible)
 
  ' insert picture in document header
  ap.ActiveWindow.ActivePane.View.SeekView = wdSeekCurrentPageHeader
  ap.Selection.InlineShapes.AddPicture FileName:="somepicture.gif", _
      LinkToFile:=False, SaveWithDocument:=True
  ap.Selection.MoveLeft Unit:=wdCharacter, Count:=1, Extend:=wdExtend
 
  ' make watermark
  ap.Selection.InlineShapes(1).PictureFormat.Brightness = 0.85
  ap.Selection.InlineShapes(1).PictureFormat.Contrast = 0.15
 
  ' convert from inlineshape to shape and set position
  ap.Selection.InlineShapes(1).ConvertToShape
  ap.Selection.ShapeRange.Top = 150
  ap.Selection.ShapeRange.Left = 150
 
  ' return from header view
  ap.ActiveWindow.ActivePane.View.SeekView = wdSeekMainDocument
 
  ' clean up
  doc.SaveAs "test.doc"
  ap.Quit
  Set doc = Nothing
  Set ap = Nothing
End Sub

Open in new window

0

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Selection object is designed for user interaction. It has a Range property, so it can be used in most places that a Range object can. Recorded macros must use the Selection because they are simply copying what the user is doing. A Range prope…
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
This Micro Tutorial well show you how to find and replace special characters in Microsoft Word. This is similar to carriage returns to convert columns of values from Microsoft Excel into comma separated lists.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question