Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
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
Reply

Tags
excel 2021, vba



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 01:28 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