Thank you for the suggestions. I haven’t had time to test this because I don’t want to edit my original macro and I don’t see a way to choose a new macro. I think I have to recreate the whole .tas file maybe?
I will update as soon as I get it to process.
From: Martin.Holkovic [mailto:bounce-MartinHolkovic@toadworld.com]
Sent: Wednesday, February 17, 2016 12:33 AM
Subject: RE: [Toad Data Point - Discussion Forum] Automation with Excel - using macro but saving file as .xlsx
RE: Automation with Excel - using macro but saving file as .xlsx
Reply by Martin.Holkovic
Maybe a workaround would be to create a macro to do something like this:
ThisWorkbook.SaveAs ThisWorkbook.Path & "\" & Mid(ThisWorkbook.Name, 1, InStrRev(ThisWorkbook.Name, ".") - 1), xlOpenXMLWorkbook
This macro simply saves the excel file where the macro runs as .xlsx file format in the current directory.
Also, please note that both .xls and .xlsb also support macros… .xlsm is 97-2003 excel format which allows you only 65k rows while xlsb is binary format which has 1 milion+ rows and the result file size is smaller…
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Unsubscribe from Toad Data Point - General notifications altogether.
Toad Data Point - Discussion Forum
this post as spam/abuse.
This e-mail message, including any attachments, is for the sole use of the person to whom it has been sent, and may contain information that is confidential or legally protected. If you are not the intended recipient or have received this message in error, you are not authorized to copy, distribute, or otherwise use this message or its attachments. Please notify the sender immediately by return e-mail and permanently delete this message and any attachments. Gartner makes no warranty that this e-mail is error or virus free.