• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1484
  • Last Modified:

excel vba: export worksheet to text file

how do i export an excel worksheet to a text file?
0
yws812
Asked:
yws812
  • 3
1 Solution
 
sunray_2003Commented:
Hmm.. I thought there was an easier way than this.

anyway check this VBA code

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

Sunray
0
 
yws812Author Commented:
sorry. didnt mean to put it as a VB question. just need to know where it is on the application toolbar
0
 
sunray_2003Commented:
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
 
byundtCommented:
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
 
sunray_2003Commented:
Thanks for the points

Thanks Brad for explaining

Sunray
0

Featured Post

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now