Re: $$Excel-Macros$$ Text file to excel
Hi Paul, Im fine with every thing but after saving the excel file to .txt it contain some additional () quotes (unwanted). can you please help me to avoid that one ? Thanks Regards, Ganesh N On Fri, Sep 5, 2014 at 8:58 AM, Ganesh N ganeshg...@gmail.com wrote: Thanks Paul. Let me check on this. Regards, Ganesh N On Thu, Sep 4, 2014 at 11:29 PM, Paul Schreiner schreiner_p...@att.net wrote: Have you tried recording a macro? When I recorded macros, I came up with: Sub Open_Macro() Workbooks.OpenText Filename:=C:\temp\mfg_appl_log.txt, Origin:=437, _ StartRow:=1, DataType:=xlDelimited, TextQualifier:=xlDoubleQuote, _ ConsecutiveDelimiter:=False, Tab:=True, Semicolon:=False, Comma:=False _ , Space:=False, Other:=True, OtherChar:=|, _ FieldInfo:=Array(Array(1, 1), Array(2, 1), Array(3, 1), Array(4, 1), _ Array(5, 1), Array(6, 1), Array(7, 1), Array(8, 1)), _ TrailingMinusNumbers:=True End Sub Sub Save_Macro() ActiveWorkbook.Save End Sub *Paul* - *“Do all the good you can,By all the means you can,In all the ways you can,In all the places you can,At all the times you can,To all the people you can,As long as ever you can.” - John Wesley* - *From:* Ganesh N ganeshg...@gmail.com *To:* excel-macros@googlegroups.com excel-macros@googlegroups.com *Sent:* Thursday, September 4, 2014 1:20 PM *Subject:* Re: $$Excel-Macros$$ Text file to excel Dear Paul, Thanks for your reply. your rite but i have to open by macro because i have to do some automation after i open the .txt file to excel. Kindly help me how to open the .txt file using macro. I mean code to open and save the same. Thanks Regards, Ganesh N On Thu, Sep 4, 2014 at 10:45 PM, Paul Schreiner schreiner_p...@att.net wrote: I'm sure I must be misunderstanding the question. Assuming your text file has a .txt extension: Why don't you simply: launch Excel File-Open Change file types to: Text Files (*.prn;*.txt;*.csv) do whatever formatting is applicable when saving, the file should default to .txt so, what am I missing in this question? *Paul* - *“Do all the good you can, By all the means you can,In all the ways you can,In all the places you can,At all the times you can,To all the people you can,As long as ever you can.” - John Wesley* - *From:* Ganesh N ganeshg...@gmail.com *To:* excel-macros@googlegroups.com excel-macros@googlegroups.com *Sent:* Thursday, September 4, 2014 11:44 AM *Subject:* $$Excel-Macros$$ Text file to excel Dear expert, I want to open the text file in excel (copy all the data from text file) and have to do some computation on excel and again I need to save the excel file to text file. I need to know how to open the text file (or how to copy the data from text file) and how to save the excel data to text file. Required your help one that. Thanks Regards, Ganesh N -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6
Re: $$Excel-Macros$$ Text file to excel
That's a bit more involved. Have you ever used the filesystem object similar to: Const ForReading = 1, ForWriting = 2, ForAppending = 8 Dim fs, f Set fs = CreateObject(Scripting.FileSystemObject) Set f = fs.OpenTextFile(c:\temp\testfile.txt, ForAppending, True) f.Write Hello world! f.Close You would open the text file, then loop through your worksheet and write each line. Usually, I build a string variable from the worksheet row and write the string. Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: Ganesh N ganeshg...@gmail.com To: excel-macros@googlegroups.com excel-macros@googlegroups.com Sent: Friday, September 5, 2014 8:12 AM Subject: Re: $$Excel-Macros$$ Text file to excel Hi Paul, Im fine with every thing but after saving the excel file to .txt it contain some additional () quotes (unwanted). can you please help me to avoid that one ? Thanks Regards, Ganesh N On Fri, Sep 5, 2014 at 8:58 AM, Ganesh N ganeshg...@gmail.com wrote: Thanks Paul. Let me check on this. Regards, Ganesh N On Thu, Sep 4, 2014 at 11:29 PM, Paul Schreiner schreiner_p...@att.net wrote: Have you tried recording a macro? When I recorded macros, I came up with: Sub Open_Macro() Workbooks.OpenText Filename:=C:\temp\mfg_appl_log.txt, Origin:=437, _ StartRow:=1, DataType:=xlDelimited, TextQualifier:=xlDoubleQuote, _ ConsecutiveDelimiter:=False, Tab:=True, Semicolon:=False, Comma:=False _ , Space:=False, Other:=True, OtherChar:=|, _ FieldInfo:=Array(Array(1, 1), Array(2, 1), Array(3, 1), Array(4, 1), _ Array(5, 1), Array(6, 1), Array(7, 1), Array(8, 1)), _ TrailingMinusNumbers:=True End Sub Sub Save_Macro() ActiveWorkbook.Save End Sub Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: Ganesh N ganeshg...@gmail.com To: excel-macros@googlegroups.com excel-macros@googlegroups.com Sent: Thursday, September 4, 2014 1:20 PM Subject: Re: $$Excel-Macros$$ Text file to excel Dear Paul, Thanks for your reply. your rite but i have to open by macro because i have to do some automation after i open the .txt file to excel. Kindly help me how to open the .txt file using macro. I mean code to open and save the same. Thanks Regards, Ganesh N On Thu, Sep 4, 2014 at 10:45 PM, Paul Schreiner schreiner_p...@att.net wrote: I'm sure I must be misunderstanding the question. Assuming your text file has a .txt extension: Why don't you simply: launch Excel File-Open Change file types to: Text Files (*.prn;*.txt;*.csv) do whatever formatting is applicable when saving, the file should default to .txt so, what am I missing in this question? Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: Ganesh N ganeshg...@gmail.com To: excel-macros@googlegroups.com excel-macros@googlegroups.com Sent: Thursday, September 4, 2014 11:44 AM Subject: $$Excel-Macros$$ Text file to excel Dear expert, I want to open the text file in excel (copy all the data from text file) and have to do some computation on excel and again I need to save the excel file to text file. I need to know how to open the text file (or how to copy the data from text file) and how to save the excel data to text file. Required your help one that. Thanks Regards, Ganesh N -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails
Re: $$Excel-Macros$$ Text file to excel
Thanks Paul. let me try on that. thanks again Regards, Ganesh N On Fri, Sep 5, 2014 at 7:38 PM, Paul Schreiner schreiner_p...@att.net wrote: That's a bit more involved. Have you ever used the filesystem object similar to: Const ForReading = 1, ForWriting = 2, ForAppending = 8 Dim fs, f Set fs = CreateObject(Scripting.FileSystemObject) Set f = fs.OpenTextFile(c:\temp\testfile.txt, ForAppending, True) f.Write Hello world! f.Close You would open the text file, then loop through your worksheet and write each line. Usually, I build a string variable from the worksheet row and write the string. *Paul* - *“Do all the good you can,By all the means you can,In all the ways you can,In all the places you can,At all the times you can,To all the people you can,As long as ever you can.” - John Wesley* - *From:* Ganesh N ganeshg...@gmail.com *To:* excel-macros@googlegroups.com excel-macros@googlegroups.com *Sent:* Friday, September 5, 2014 8:12 AM *Subject:* Re: $$Excel-Macros$$ Text file to excel Hi Paul, Im fine with every thing but after saving the excel file to .txt it contain some additional () quotes (unwanted). can you please help me to avoid that one ? Thanks Regards, Ganesh N On Fri, Sep 5, 2014 at 8:58 AM, Ganesh N ganeshg...@gmail.com wrote: Thanks Paul. Let me check on this. Regards, Ganesh N On Thu, Sep 4, 2014 at 11:29 PM, Paul Schreiner schreiner_p...@att.net wrote: Have you tried recording a macro? When I recorded macros, I came up with: Sub Open_Macro() Workbooks.OpenText Filename:=C:\temp\mfg_appl_log.txt, Origin:=437, _ StartRow:=1, DataType:=xlDelimited, TextQualifier:=xlDoubleQuote, _ ConsecutiveDelimiter:=False, Tab:=True, Semicolon:=False, Comma:=False _ , Space:=False, Other:=True, OtherChar:=|, _ FieldInfo:=Array(Array(1, 1), Array(2, 1), Array(3, 1), Array(4, 1), _ Array(5, 1), Array(6, 1), Array(7, 1), Array(8, 1)), _ TrailingMinusNumbers:=True End Sub Sub Save_Macro() ActiveWorkbook.Save End Sub *Paul* - *“Do all the good you can,By all the means you can,In all the ways you can,In all the places you can,At all the times you can,To all the people you can,As long as ever you can.” - John Wesley* - *From:* Ganesh N ganeshg...@gmail.com *To:* excel-macros@googlegroups.com excel-macros@googlegroups.com *Sent:* Thursday, September 4, 2014 1:20 PM *Subject:* Re: $$Excel-Macros$$ Text file to excel Dear Paul, Thanks for your reply. your rite but i have to open by macro because i have to do some automation after i open the .txt file to excel. Kindly help me how to open the .txt file using macro. I mean code to open and save the same. Thanks Regards, Ganesh N On Thu, Sep 4, 2014 at 10:45 PM, Paul Schreiner schreiner_p...@att.net wrote: I'm sure I must be misunderstanding the question. Assuming your text file has a .txt extension: Why don't you simply: launch Excel File-Open Change file types to: Text Files (*.prn;*.txt;*.csv) do whatever formatting is applicable when saving, the file should default to .txt so, what am I missing in this question? *Paul* - *“Do all the good you can, By all the means you can,In all the ways you can,In all the places you can,At all the times you can,To all the people you can,As long as ever you can.” - John Wesley* - *From:* Ganesh N ganeshg...@gmail.com *To:* excel-macros@googlegroups.com excel-macros@googlegroups.com *Sent:* Thursday, September 4, 2014 11:44 AM *Subject:* $$Excel-Macros$$ Text file to excel Dear expert, I want to open the text file in excel (copy all the data from text file) and have to do some computation on excel and again I need to save the excel file to text file. I need to know how to open the text file (or how to copy the data from text file) and how to save the excel data to text file. Required your help one that. Thanks Regards, Ganesh N -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data
$$Excel-Macros$$ Text file to excel
Dear expert, I want to open the text file in excel (copy all the data from text file) and have to do some computation on excel and again I need to save the excel file to text file. I need to know how to open the text file (or how to copy the data from text file) and how to save the excel data to text file. Required your help one that. Thanks Regards, Ganesh N -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Text file to excel
I'm sure I must be misunderstanding the question. Assuming your text file has a .txt extension: Why don't you simply: launch Excel File-Open Change file types to: Text Files (*.prn;*.txt;*.csv) do whatever formatting is applicable when saving, the file should default to .txt so, what am I missing in this question? Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: Ganesh N ganeshg...@gmail.com To: excel-macros@googlegroups.com excel-macros@googlegroups.com Sent: Thursday, September 4, 2014 11:44 AM Subject: $$Excel-Macros$$ Text file to excel Dear expert, I want to open the text file in excel (copy all the data from text file) and have to do some computation on excel and again I need to save the excel file to text file. I need to know how to open the text file (or how to copy the data from text file) and how to save the excel data to text file. Required your help one that. Thanks Regards, Ganesh N -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Text file to excel
Dear Paul, Thanks for your reply. your rite but i have to open by macro because i have to do some automation after i open the .txt file to excel. Kindly help me how to open the .txt file using macro. I mean code to open and save the same. Thanks Regards, Ganesh N On Thu, Sep 4, 2014 at 10:45 PM, Paul Schreiner schreiner_p...@att.net wrote: I'm sure I must be misunderstanding the question. Assuming your text file has a .txt extension: Why don't you simply: launch Excel File-Open Change file types to: Text Files (*.prn;*.txt;*.csv) do whatever formatting is applicable when saving, the file should default to .txt so, what am I missing in this question? *Paul* - *“Do all the good you can,By all the means you can,In all the ways you can,In all the places you can,At all the times you can,To all the people you can,As long as ever you can.” - John Wesley* - *From:* Ganesh N ganeshg...@gmail.com *To:* excel-macros@googlegroups.com excel-macros@googlegroups.com *Sent:* Thursday, September 4, 2014 11:44 AM *Subject:* $$Excel-Macros$$ Text file to excel Dear expert, I want to open the text file in excel (copy all the data from text file) and have to do some computation on excel and again I need to save the excel file to text file. I need to know how to open the text file (or how to copy the data from text file) and how to save the excel data to text file. Required your help one that. Thanks Regards, Ganesh N -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from
Re: $$Excel-Macros$$ Text file to excel
Have you tried recording a macro? When I recorded macros, I came up with: Sub Open_Macro() Workbooks.OpenText Filename:=C:\temp\mfg_appl_log.txt, Origin:=437, _ StartRow:=1, DataType:=xlDelimited, TextQualifier:=xlDoubleQuote, _ ConsecutiveDelimiter:=False, Tab:=True, Semicolon:=False, Comma:=False _ , Space:=False, Other:=True, OtherChar:=|, _ FieldInfo:=Array(Array(1, 1), Array(2, 1), Array(3, 1), Array(4, 1), _ Array(5, 1), Array(6, 1), Array(7, 1), Array(8, 1)), _ TrailingMinusNumbers:=True End Sub Sub Save_Macro() ActiveWorkbook.Save End Sub Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: Ganesh N ganeshg...@gmail.com To: excel-macros@googlegroups.com excel-macros@googlegroups.com Sent: Thursday, September 4, 2014 1:20 PM Subject: Re: $$Excel-Macros$$ Text file to excel Dear Paul, Thanks for your reply. your rite but i have to open by macro because i have to do some automation after i open the .txt file to excel. Kindly help me how to open the .txt file using macro. I mean code to open and save the same. Thanks Regards, Ganesh N On Thu, Sep 4, 2014 at 10:45 PM, Paul Schreiner schreiner_p...@att.net wrote: I'm sure I must be misunderstanding the question. Assuming your text file has a .txt extension: Why don't you simply: launch Excel File-Open Change file types to: Text Files (*.prn;*.txt;*.csv) do whatever formatting is applicable when saving, the file should default to .txt so, what am I missing in this question? Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: Ganesh N ganeshg...@gmail.com To: excel-macros@googlegroups.com excel-macros@googlegroups.com Sent: Thursday, September 4, 2014 11:44 AM Subject: $$Excel-Macros$$ Text file to excel Dear expert, I want to open the text file in excel (copy all the data from text file) and have to do some computation on excel and again I need to save the excel file to text file. I need to know how to open the text file (or how to copy the data from text file) and how to save the excel data to text file. Required your help one that. Thanks Regards, Ganesh N -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Text file to excel
Thanks Paul. Let me check on this. Regards, Ganesh N On Thu, Sep 4, 2014 at 11:29 PM, Paul Schreiner schreiner_p...@att.net wrote: Have you tried recording a macro? When I recorded macros, I came up with: Sub Open_Macro() Workbooks.OpenText Filename:=C:\temp\mfg_appl_log.txt, Origin:=437, _ StartRow:=1, DataType:=xlDelimited, TextQualifier:=xlDoubleQuote, _ ConsecutiveDelimiter:=False, Tab:=True, Semicolon:=False, Comma:=False _ , Space:=False, Other:=True, OtherChar:=|, _ FieldInfo:=Array(Array(1, 1), Array(2, 1), Array(3, 1), Array(4, 1), _ Array(5, 1), Array(6, 1), Array(7, 1), Array(8, 1)), _ TrailingMinusNumbers:=True End Sub Sub Save_Macro() ActiveWorkbook.Save End Sub *Paul* - *“Do all the good you can,By all the means you can,In all the ways you can,In all the places you can,At all the times you can,To all the people you can,As long as ever you can.” - John Wesley* - *From:* Ganesh N ganeshg...@gmail.com *To:* excel-macros@googlegroups.com excel-macros@googlegroups.com *Sent:* Thursday, September 4, 2014 1:20 PM *Subject:* Re: $$Excel-Macros$$ Text file to excel Dear Paul, Thanks for your reply. your rite but i have to open by macro because i have to do some automation after i open the .txt file to excel. Kindly help me how to open the .txt file using macro. I mean code to open and save the same. Thanks Regards, Ganesh N On Thu, Sep 4, 2014 at 10:45 PM, Paul Schreiner schreiner_p...@att.net wrote: I'm sure I must be misunderstanding the question. Assuming your text file has a .txt extension: Why don't you simply: launch Excel File-Open Change file types to: Text Files (*.prn;*.txt;*.csv) do whatever formatting is applicable when saving, the file should default to .txt so, what am I missing in this question? *Paul* - *“Do all the good you can, By all the means you can,In all the ways you can,In all the places you can,At all the times you can,To all the people you can,As long as ever you can.” - John Wesley* - *From:* Ganesh N ganeshg...@gmail.com *To:* excel-macros@googlegroups.com excel-macros@googlegroups.com *Sent:* Thursday, September 4, 2014 11:44 AM *Subject:* $$Excel-Macros$$ Text file to excel Dear expert, I want to open the text file in excel (copy all the data from text file) and have to do some computation on excel and again I need to save the excel file to text file. I need to know how to open the text file (or how to copy the data from text file) and how to save the excel data to text file. Required your help one that. Thanks Regards, Ganesh N -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA