Solved

excel vba: export worksheet to text file

Posted on 2003-12-09
5
1,416 Views
Last Modified: 2007-12-19
how do i export an excel worksheet to a text file?
0
Comment
Question by:yws812
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
5 Comments
 
LVL 49

Accepted Solution

by:
sunray_2003 earned 50 total points
ID: 9903929
Hmm.. I thought there was an easier way than this.

anyway check this VBA code

http://www.cpearson.com/excel/imptext.htm

Sunray
0
 

Author Comment

by:yws812
ID: 9904062
sorry. didnt mean to put it as a VB question. just need to know where it is on the application toolbar
0
 
LVL 49

Expert Comment

by:sunray_2003
ID: 9904128
yws812,

I am not seeing any export function in toolbar ( may be I have to research more on that)
But when you save a worksheet do this .
go to file --> Save as
Give the file name and save as text file

Thanks,
Sunray
0
 
LVL 81

Expert Comment

by:byundt
ID: 9904212
Hi yws812,
Chip Pearson's code gives you control over the separator character--comma, semicolon, blank, tab, etc. between each successive cell.

If you don't need this control, then you can save as .csv or .txt file using the File...Save As dialog suggested by Sunray.

Cheers!

Brad
0
 
LVL 49

Expert Comment

by:sunray_2003
ID: 9904262
Thanks for the points

Thanks Brad for explaining

Sunray
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
Outlook for dependable use in a very small business   This article is about using the Outlook application (part of Microsoft Office) in a very small business, or for homeowners where dependability and reliability are critical requirements. This …
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question