# xls vs xlsx

**URL:** <https://forums.toadworld.com/t/xls-vs-xlsx/6598>\
**Category:** Toad Data Point & Toad Intelligence Central\
**Created:** [May 10, 2011, 11:55am UTC](https://forums.toadworld.com/t/xls-vs-xlsx/6598 "2011-05-10T11:55:04Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![paulsm\_1239978168796](https://avatars.discourse-cdn.com/v4/letter/p/e5b9ba/32.png) [@paulsm\_1239978168796](https://forums.toadworld.com/u/paulsm_1239978168796)\
**Post date:** [May 10, 2011, 11:55am UTC](https://forums.toadworld.com/t/xls-vs-xlsx/6598/1 "2011-05-10T11:55:04Z")

</div>

I have a large automated export containing numerous export templates exporting to excel files with numerous tabs in each file. I decided to remove the addition of the date/time suffix and add a macro to change the name and the areas I want the files copied to. When I removed the suffix the script blows up and the file becomes corrupted. I changed the file to xls and it runs. Is there any reason this should act this way?. Is there something I can do to change it? Sometimes I will have more than 65K lines and xls will not work for me.

---

<div class="post-metadata">

**Author:** ![Debbie\_Peabody](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/debbie_peabody/32/18_2.png) [@Debbie\_Peabody](https://forums.toadworld.com/u/Debbie_Peabody)\
**Post date:** [May 10, 2011, 3:05pm UTC](https://forums.toadworld.com/t/xls-vs-xlsx/6598/2 "2011-05-10T15:05:35Z")

</div>

Supporting macros in \*xlsm files was added to TDA 2.7. Are you using an \*xlsm file and have macro security turned off?

When you have a file with a macro you should see it in the export wizard and it will give you a choice to run the macro before or after your export. So the macro has to be in the report you are running. You also have to not overwrite the file.

Check these items and see if that helps. If not, perhaps you can give me some more details on the macro and how you are using it. (Or sample file with macro in it for me to test would be great too)

Debbie

 ![ExcelMacros.png](https://global.discourse-cdn.com/quest/original/2X/2/27846129aceeef4d5ac15e92138f40d89727edb0.png)

---

<div class="post-metadata">

**Author:** ![paulsm\_1239978168796](https://avatars.discourse-cdn.com/v4/letter/p/e5b9ba/32.png) [@paulsm\_1239978168796](https://forums.toadworld.com/u/paulsm_1239978168796)\
**Post date:** [May 10, 2011, 3:17pm UTC](https://forums.toadworld.com/t/xls-vs-xlsx/6598/3 "2011-05-10T15:17:13Z")

</div>

Debbie,

I have not created the macro yet, so this is not part of the problem. All I had done was change the automation to not include a suffix.

---

<div class="post-metadata">

**Author:** ![Debbie\_Peabody](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/debbie_peabody/32/18_2.png) [@Debbie\_Peabody](https://forums.toadworld.com/u/Debbie_Peabody)\
**Post date:** [May 10, 2011, 3:41pm UTC](https://forums.toadworld.com/t/xls-vs-xlsx/6598/4 "2011-05-10T15:41:17Z")

</div>

I see. Can you change the logging level to Verbose, run the script and send me the whole log file? I need to see details on how it is failing.

Debbie  
[dpeabody@quest.com](mailto:dpeabody@quest.com)

---

<div class="post-metadata">

**Author:** ![nikdyner](https://avatars.discourse-cdn.com/v4/letter/n/a4c791/32.png) [@nikdyner](https://forums.toadworld.com/u/nikdyner)\
**Post date:** [July 10, 2012, 11:08am UTC](https://forums.toadworld.com/t/xls-vs-xlsx/6598/5 "2012-07-10T11:08:19Z")

</div>

To open, read, scan, extract and even recover \*.xls, \*,xlt, \*.xlsx, xlsm, \*.xltm, \*.xltx, \*.xlam file formats you may use [http://www.recoverytoolbox.com/excel.html](http://www.recoverytoolbox.com/excel.html)