Avatar of jdc1944
jdc1944
Flag for United Kingdom of Great Britain and Northern Ireland asked on

Problems in VBA and Word

I have an issue with the VB code I have written in VBA 6.5.  We have today moved to a new environment and all our systems have been upgraded from Office 2003, Windows XP, VBA 6.5 to Office 2010, Windows 7, VBA 7.
I have a word document which I have now saved from .doc to .docm because of all the macros.  When a command button on this document is pressed it opens up another word document that is not visible to the user.  It adds numerous data to the new document and saves it.  One of the things it does is adds information in the header.  This all used to work fine until the changes today.  Now everything works fine but the information that is meant to go into the header is actually put into the body of the document where the code is running from, i.e the wrong document.  Can anyone see anything in the code that might be causing this to happen?  I wouldn’t say I am particularly advanced in VB.


'Add job name and ref to the header
       If Documents(matrixdoc).ActiveWindow.View.SplitSpecial <> wdPaneNone Then
        Documents(matrixdoc).ActiveWindow.Panes(2).Close
    End If
    If Documents(matrixdoc).ActiveWindow.ActivePane.View.Type = wdNormalView Or ActiveWindow.ActivePane.View.Type = wdOutlineView Then
        Documents(matrixdoc).ActiveWindow.ActivePane.View.Type = wdPrintView
    End If
    Documents(matrixdoc).ActiveWindow.ActivePane.View.SeekView = wdSeekCurrentPageHeader
    Selection.MoveDown Unit:=wdLine, Count:=2
    Selection.EndKey Unit:=wdLine
    Selection.MoveRight Unit:=wdCharacter, Count:=1
    Selection.TypeText Text:=job_Name
    Selection.MoveDown Unit:=wdLine, Count:=1
    Selection.TypeText Text:=job_Ref
    Selection.MoveRight Unit:=wdCharacter, Count:=1
    Selection.EndKey Unit:=wdLine
    Selection.MoveRight Unit:=wdCharacter, Count:=1
    Selection.TypeText Text:=Date
    Selection.MoveUp Unit:=wdLine, Count:=1
    Selection.TypeText Text:=Initials
    Documents(matrixdoc).ActiveWindow.ActivePane.View.SeekView = wdSeekMainDocument

Open in new window

Microsoft Word

Avatar of undefined
Last Comment
jdc1944

8/22/2022 - Mon
GrahamSkan

There is an inherent problem in using the Selection object. It isn't easy to keep track of where it is.

Try replacing lines 1 to 8 with this line:
   
 Documents(matrixdoc).Sections(1).Headers(wdHeaderFooterPrimary).Range.Select

Open in new window

jdc1944

ASKER
Thanks for that but i'm a little confused how I can use that to replace lines 1-8 with what you have suggested.  

I take it you don't mean literally replace lines 1-8 with that?  I just can't see how i can integrate it.
ASKER CERTIFIED SOLUTION
GrahamSkan

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
jdc1944

ASKER
Thanks for that, solves the issue.

Just had to append:

Documents(matrixdoc).ActiveWindow.View = wdPrintView
Your help has saved me hundreds of hours of internet surfing.
fblack61