how do I export a worksheet as a fixed format ascii file

I need to save a worksheet as a fixed format ascii file, where each column in
the worksheet starts in a specific column on the file and is a specific
length. In much earlier versions of excel you could export the worksheet and
create a template. I can not find this function in the newer versions of
excel for exporting data. It's there for importing, not not exporting. Any
help will be greatly appreciated

One way:

http://www.mcgimpsey.com/excel/textf...tml#fixedfield

In article <5D095F38-9955-42E6-A99D-9313381D5377@microsoft.com>,
"SVANATTA65" <SVANATTA65@discussions.microsoft.com> wrote:

> I need to save a worksheet as a fixed format ascii file, where each column in
> the worksheet starts in a specific column on the file and is a specific
> length. In much earlier versions of excel you could export the worksheet and
> create a template. I can not find this function in the newer versions of
> excel for exporting data. It's there for importing, not not exporting. Any
> help will be greatly appreciated

I've heard folks have had good success using the prn file format, though you
have to do some stuff to make it work right. Take a look at
http://www.smokeylake.com/excel/textfiles.htm. Look at section "Space
delimited *.prn."

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"SVANATTA65" <SVANATTA65@discussions.microsoft.com> wrote in message
news:5D095F38-9955-42E6-A99D-9313381D5377@microsoft.com...
>I need to save a worksheet as a fixed format ascii file, where each column
>in
> the worksheet starts in a specific column on the file and is a specific
> length. In much earlier versions of excel you could export the worksheet
> and
> create a template. I can not find this function in the newer versions of
> excel for exporting data. It's there for importing, not not exporting.
> Any
> help will be greatly appreciated