+ Reply to Thread
Results 1 to 3 of 3

open the styles.xml and edit it to have no styles

  1. #1
    Forum Expert
    Join Date
    04-01-2013
    Location
    East Auckland
    MS-Off Ver
    Excel 365
    Posts
    1,343

    open the styles.xml and edit it to have no styles

    For whatever reason running the normal VBA that would delete styles is taking a long time to run (to delete my over 50,000 styles) and is failing to do anything anyway.
    I would like to instead be able to use VBA code to do the below

    Which basically opens up the styles.xml that is zipped in the excel file and blow away the styles.

    this is better than doing it manually as
    A) I want users to be able to fix it themselves
    B) This is pretty hard to do in notepad anyway, and i can't have decent text exiting software.

    Please Login or Register  to view this content.
    NB: I had to edit the xml to let it upload so i edited in spaces next to the < and > in the xml code
    Last edited by scottiex; 09-11-2018 at 09:15 PM.
    If you want something done right... find a forum and ask an online expert.

    Time flies like an arrow. Fruit flies like a banana.

  2. #2
    Forum Expert
    Join Date
    04-01-2013
    Location
    East Auckland
    MS-Off Ver
    Excel 365
    Posts
    1,343

    Re: open the styles.xml and edit it to have no styles

    So step 1 is ok

    Please Login or Register  to view this content.
    and if i use that then my path to the styles folder would be -
    Please Login or Register  to view this content.
    but what next?

  3. #3
    Forum Expert
    Join Date
    04-01-2013
    Location
    East Auckland
    MS-Off Ver
    Excel 365
    Posts
    1,343

    Re: open the styles.xml and edit it to have no styles

    OK
    i think i have the basic steps here done reasonably efficiently

    Please Login or Register  to view this content.
    Last edited by scottiex; 09-12-2018 at 10:34 PM.

+ 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. Can't Edit or Delete Custom Pivot Table Styles
    By HangMan in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 11-26-2019, 07:24 AM
  2. How do I delete styles?
    By Dave H in forum Excel General
    Replies: 18
    Last Post: 02-13-2015, 04:56 PM
  3. Replies: 1
    Last Post: 03-08-2013, 02:05 PM
  4. Keep Cell Styles open
    By Rawhead in forum Excel General
    Replies: 0
    Last Post: 08-03-2012, 11:10 AM
  5. linked styles
    By damo_uk in forum Word Formatting & General
    Replies: 2
    Last Post: 12-08-2009, 01:21 PM
  6. [SOLVED] Outline Styles
    By teksmith in forum Excel General
    Replies: 1
    Last Post: 03-24-2006, 11:55 AM
  7. [SOLVED] new marker styles
    By Lis in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 08-30-2005, 07:05 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