Text to Columns issue

Hi,

The accounting program that I use does not have a well formatted excel
download, so it is better to dump the data into notepad and then format it.
I have created a macro to do the formatting for me. The only trouble is that
if I open excel, and I run the macro, if I want to put new data in the file
to run the macro on, excel has already converted the data to columns, and my
macro no longer works correctly. The only way I can fix it, and have all of
the data show up in column A (with | as a delimiter) is close the entire
program and launch it again. Does anyone know how to correct this?
--
Thanks for all of the help. It is much appreciated!!!!

As ALWAYS, post your code for comments.
Have your macro, first do a dummy TTC with defaults.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Bean Counter" wrote in message
...
Hi,

The accounting program that I use does not have a well formatted excel
download, so it is better to dump the data into notepad and then format
it.
I have created a macro to do the formatting for me. The only trouble is
that
if I open excel, and I run the macro, if I want to put new data in the
file
to run the macro on, excel has already converted the data to columns, and
my
macro no longer works correctly. The only way I can fix it, and have all
of
the data show up in column A (with | as a delimiter) is close the entire
program and launch it again. Does anyone know how to correct this?
--
Thanks for all of the help. It is much appreciated!!!!

Hi Everyone - sometimes a delay in getting answers helps you to find the
solution for yourself...

I did a search in the forum, and I found this solution...I added the code on
the below worksheet (link provided by Biff - excel MVP) to my macro, and it
works beautifully.. I LOVE EXCEL!!!


http://spreadsheetpage.com/index.php...ns_parameters/


--
Thanks for all of the help. It is much appreciated!!!!


"Bean Counter" wrote:

Hi,

The accounting program that I use does not have a well formatted excel
download, so it is better to dump the data into notepad and then format it.
I have created a macro to do the formatting for me. The only trouble is that
if I open excel, and I run the macro, if I want to put new data in the file
to run the macro on, excel has already converted the data to columns, and my
macro no longer works correctly. The only way I can fix it, and have all of
the data show up in column A (with | as a delimiter) is close the entire
program and launch it again. Does anyone know how to correct this?
--
Thanks for all of the help. It is much appreciated!!!!