+ Reply to Thread
Results 1 to 2 of 2

Copy to & apply style from another document - not all properties depend on style

  1. #1
    Registered User
    Join Date
    03-11-2019
    Location
    Slovenija
    MS-Off Ver
    2016/365
    Posts
    9

    Copy to & apply style from another document - not all properties depend on style

    There is new file template design with some 25+ styles ( call it A file) and 200+ old files that should be redesigned according to new template, lets call them B files.

    I wrote a VBA code to automatically loop and copy styles from new A template to hundreds old B files and replace& redesign old styles with new.

    There seem to be a major problem as some properties in new styles are not applied correctly - some properties obviously depend on document theme. Designer seems to make a mistake and used different themes in old and new documents types. An example are new Header styles that apply wrong font type in old files. OK we solved this with Font Property but this problem drags on most painfully in tables where design is applied with style.

    Is there any workaround?

  2. #2
    Forum Guru macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,642

    Re: Copy to & apply style from another document - not all properties depend on style

    See: https://www.msofficeforums.com/28497-post34.html
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Auto apply style to existing worksheet when anything changes ?
    By jools1961 in forum Excel General
    Replies: 5
    Last Post: 04-06-2017, 02:06 AM
  2. Convert R1C1 Style to A1 style
    By m1ngle in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 11-17-2016, 08:38 PM
  3. [SOLVED] Transform Data From Pivot Style to a Table Style
    By The_Snook in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-18-2016, 04:13 AM
  4. Normal Style to No Spacing Style by default.
    By dogberry in forum Word Formatting & General
    Replies: 1
    Last Post: 12-23-2012, 11:48 PM
  5. Apply same pivot style to new data
    By fab. in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 10-19-2012, 04:36 AM
  6. [SOLVED] Design - Table style only coloring in the header and first row - how to get it to apply to
    By KathleenTurnis in forum Excel - New Users/Basics
    Replies: 7
    Last Post: 09-18-2012, 10:37 AM
  7. Auto apply a style to a number
    By bobslay71 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-08-2012, 12:34 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1