Macro to convert Text files into Excel file

[Kazdima]

Hello,

I would appreciate aveone's help to write for me a Macro to Convert a Text file into Excel file.
I will send a Text file and an example of an Excel format file to those who can help me.

Thank you,

Dan

 

[CMHerrera1]

Re: Macro to convert Text file into Excel file

I was referring to the Text file you are converting. Is it named the same thing every time?
If not, we can have the Macro open the file browser, so you pick the file, and the macro does the rest.
If it is named the same thing every time, then you can leave it as it is.

Can you please add this feature to the macro above. The text file I have will not be named the same every time.

 

[Joe4]

See this post here: VBA code that prompts user to select file and copy data from workbook
Just change the filters to look for the file type/extension you are looking for.

 

[Joemamasuka]

Re: Macro to convert Text file into Excel file

I was referring to the Text file you are converting. Is it named the same thing every time?
If not, we can have the Macro open the file browser, so you pick the file, and the macro does the rest.
If it is named the same thing every time, then you can leave it as it is.

Hi Joe4 or anyone that can help...my macro has no problem opening text file, converting delimited fields, selecting data columns then charting and moving to another sheet then saving as an*.xls. I need help figuring out how to have the Macro open the file browser, so you pick the file and choosing the file destination where it is to be saved...

 

[Joe4]

Hi Joe4 or anyone that can help...my macro has no problem opening text file, converting delimited fields, selecting data columns then charting and moving to another sheet then saving as an*.xls. I need help figuring out how to have the Macro open the file browser, so you pick the file and choosing the file destination where it is to be saved...

It is usually best to post your question to a brand new thread, so everyone will see it as a new, unanswered question (that will show up on the "Unanswered threads" list), than it is to post back to an old thread (especially when you are asking about a different issue).

 

[Joemamasuka]

It is usually best to post your question to a brand new thread, so everyone will see it as a new, unanswered question (that will show up on the "Unanswered threads" list), than it is to post back to an old thread (especially when you are asking about a different issue).

Thank you. I’ll take that as a no then.

 

[Joe4]

Thank you. I’ll take that as a no then.

No, that is not what I am saying.

It can be done, and I am sure someone would be willing to show you how. But you should post your questions to their own new threads instead of posting them on to old threads.
Many people look to the "Unanswered threads" listing to find new questions to answer. If you post to existing threads, your questions will not be seen by most people.

This question has also come up many times in the past, and there are past threads on this board which show you how to do this.