?
Solved

excel vba: export worksheet to text file

Posted on 2003-12-09
5
Medium Priority
?
1,440 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 200 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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
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…

801 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