Deleting Corrupt styles

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

Hello,

Is there any way of purging styles that can't be deleted through VBA due to
some corrupt characters embedded within the style names ? I think the
problem I'm facing may be due to the multi-national nature of my
spreadsheets, however I can't pinpoint the source language of the
corruption.

Any suggestions ?
 
Hi Steve,
Is there any way of purging styles that can't be deleted through VBA due to
some corrupt characters embedded within the style names ? I think the
problem I'm facing may be due to the multi-national nature of my
spreadsheets, however I can't pinpoint the source language of the
corruption.
Click to expand...

Have you tried putting the workbook through a HTML roundtrip?

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Returning the name of a deleted cell style 6
Corrupt styles in Word 2007 vs Word 2003 template organizer 2
Removing Corrupt styles in an excel workbook 1
Close/Delete corrupt or open spreadsheet 1
In VBA, check if file is corrupt or not Excel 5
Word styles 2
Automating via VBA - Delete "Corrupt" Excel Names 1
Excel 2007 chart line width + axis labelling with VBA 6

Back
Top