Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 10-10-2020, 10:43 AM
John 4 John 4 is offline Applying heading styles from normal template to all files in a folder Windows 10 Applying heading styles from normal template to all files in a folder Office 2013
Advanced Beginner
Applying heading styles from normal template to all files in a folder
 
Join Date: Oct 2019
Posts: 68
John 4 is on a distinguished road
Default Applying heading styles from normal template to all files in a folder


I got the code below from one of Macropod's posts on another thread. I recorded a macro of me applying the Styles to one of the desired files and was hoping I could cut and paste with a little modification to get it to work in Macropod's macro. The entire macro i recorded isn't here, just one relevant part (and the most relevant part of that is bolded).

I had hoped something like "strFolder\strFile" in the place of the bolded section would work, but of course it doesn't. Could one of you do whatever tweaking is necessary to get it work please? Thanks for your help.


Code:
Sub UpdateDocuments()
Application.ScreenUpdating = False
Dim strFolder As String, strFile As String, strDocNm As String, wdDoc As Document
strDocNm = ActiveDocument.FullName: strFolder = GetFolder
If strFolder = "" Then Exit Sub
strFile = Dir(strFolder & "\*.docx", vbNormal)
While strFile <> ""
  If strFolder & "" & strFile <> strDocNm Then
    Set wdDoc = Documents.Open(FileName:=strFolder & "" & strFile, AddToRecentFiles:=False, Visible:=False)
    With wdDoc

      'Call your other macro or insert its code here
          With ActiveDocument
        .UpdateStylesOnOpen = False
        .AttachedTemplate = "Normal"
    End With
    Application.OrganizerCopy Source:= _
        "C:\Users\MyName\AppData\Roaming\Microsoft\Templates\Normal.dotm", _
        Destination:= _
        "C:\Users\MyName\Documents\FolderName\FileName.docx" _
        , Name:="Default", Object:=wdOrganizerObjectStyles

      .Close SaveChanges:=True
    End With
  End If
  strFile = Dir()
Wend
Set wdDoc = Nothing
Application.ScreenUpdating = True
End Sub
 
Function GetFolder() As String
Dim oFolder As Object
GetFolder = ""
Set oFolder = CreateObject("Shell.Application").BrowseForFolder(0, "Choose a folder", 0)
If (Not oFolder Is Nothing) Then GetFolder = oFolder.Items.Item.Path
Set oFolder = Nothing
End Function
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Applying heading styles from normal template to all files in a folder Normal.dot Relationship of document and template. Durability of Styles when doc sent. crw1@y7mail.com Word 6 07-29-2020 03:08 PM
Keeping or restoring "Start at" value for heading list after updating styles from a template WordUser789 Word VBA 9 04-15-2019 12:16 AM
Styles and not applying correctly GinnyBcore Word 1 10-02-2018 03:18 PM
Applying a new theme to a new template in 2016 moves graphics in the template around dianahbr PowerPoint 0 02-27-2018 11:04 AM
Applying heading styles from normal template to all files in a folder Movable Word template with linked files and hidden folder Elmobram22 Word 6 11-15-2013 02:11 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:39 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft