Text to Columns issue
in [General]
|
From: Bean Counter on 27 May 2010 17:18 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!!!!
From: Don Guillett on 27 May 2010 19:11 As ALWAYS, post your code for comments. Have your macro, first do a dummy TTC with defaults. -- Don Guillett Microsoft MVP Excel SalesAid Software dguillett(a)gmail.com "Bean Counter" <BeanCounter(a)discussions.microsoft.com> wrote in message news:3A9A5BB9-D880-4388-9E51-63AFBFDE5D03(a)microsoft.com... > 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!!!!
From: Bean Counter on 27 May 2010 19:19 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/tip/clearing_the_text_to_columns_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!!!!
|
Pages: 1 Prev: How to create a crosstab in Excel Next: How to print one header over several columns of data |