Searching xlsm Files in Excel 2010

Tool for Search and Replace across multiple files.
Post Reply
rockfordman
Posts: 1
Joined: Wed Feb 05, 2014 5:33 pm

Searching xlsm Files in Excel 2010

Post by rockfordman »

Your Text Crawler program works great on old Excel files from Office 2000. Since we've upgraded to Office 2010 the Text Crawler will no longer find text in these files.

Is there a fix for this already or one planned in the near future?
User avatar
DigitalVolcano
Site Admin
Posts: 1729
Joined: Thu Jun 09, 2011 10:04 am

Re: Searching xlsm Files in Excel 2010

Post by DigitalVolcano »

The new xlsm files are basically zip files with metadata inside. TextCrawler won't read these because it doesn't (as of version 2.5) support zip files. That said, it was risky using TextCrawler on the old xls files, as it could damage them (they are propriety binary formats). It's really intended for plain ASCII or Unicode text formats.
Post Reply