Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 03-23-2024, 01:03 PM
ArviLaanemets ArviLaanemets is offline Convert excel file to text file using vba Windows 8 Convert excel file to text file using vba Office 2016
Expert
 
Join Date: May 2017
Posts: 949
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default

A simpler way:

1. Read your original table (or values from columns you want to transfer) into (starting from row from where to read data without headers) array variable;
2. Create an empty text file with a name you want on destination you want;
3. In For cycle (from 1st row of array to last one), read 1st array row and create a string form all array values in this array row, plus a code for next row at end of string;
4. Write the gotten string into text file;
5. Repeat the cycle of p3 and p4 until end of For cycle;
6. Save the text file.
Reply With Quote
 

Tags
excel 2021, vba

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Convert excel file to text file using vba Importing\convert a bin file to Excel shabbaranks Excel Programming 1 07-10-2014 12:18 AM
Convert excel file to text file using vba How do you convert a csv file to appear properly in Excel 2013? DBlomgren Excel 3 05-22-2014 01:28 PM
Convert excel file to text file using vba Convert excel file 2010(64 bit) to 2003 Tyberian1988 Excel Programming 1 03-10-2014 11:39 PM
A serious problem in integrating text file with an Excel file? mradmin Excel 12 10-25-2013 07:43 AM
Convert excel file to text file using vba How to convert a text file to an Excel file with the data format automatically? mradmin Excel 6 10-16-2013 10:34 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:56 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft