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.
NB: I had to edit the xml to let it upload so i edited in spaces next to the < and > in the xml code![]()
Please Login or Register to view this content.
Bookmarks