Can you please add this feature to the macro above. The text file I have will not be named the same every time.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...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.
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).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...
Thank you. I’ll take that as a no then.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).
No, that is not what I am saying.Thank you. I’ll take that as a no then.