Hi,
I created a simple macro that saves a specific sheet as a tab-delimited txt.file.
I first created it in Excel 2013 and it worked fine.
When I draged it into Excel 2010 one of the columns receives another format when converted into txt.
In excel it look like this:
<tbody>
</tbody>
But when saved as tab-delimited .txt the result is:
<tbody>
</tbody>
Code:
Any idea why it differ between Excel 2010 and 2013 and do you have any ideas how to solve it?
Best regards,
Gustav
I created a simple macro that saves a specific sheet as a tab-delimited txt.file.
I first created it in Excel 2013 and it worked fine.
When I draged it into Excel 2010 one of the columns receives another format when converted into txt.
In excel it look like this:
deal_dt |
21/03/2016 |
21/03/2016 |
21/03/2016 |
21/03/2016 |
<tbody>
</tbody>
But when saved as tab-delimited .txt the result is:
deal_dt |
3/21/2016 |
3/21/2016 |
3/21/2016 |
3/21/2016 |
<tbody>
</tbody>
Code:
Code:
Application.DisplayAlerts = False
Application.ScreenUpdating = False
Windows("myfile.xlsm").Activate
Sheets("Output").Select
Sheets("Output").Copy
ActiveSheet.SaveAs Filename:= _
"myfile.txt", FileFormat:= _
xlTextWindows, CreateBackup:=False
ActiveWorkbook.Close
Code:
Any idea why it differ between Excel 2010 and 2013 and do you have any ideas how to solve it?
Best regards,
Gustav