Save txt as csv file

Updated my answer. Busse Thank you so much for you wonderful and detailed answer. Not only has it worked like a charm but you have given me some extra learning which is really useful. Glad it helped. Please mark it as the correct answer : As for your other question s , once you open the file you can just ActiveWorkbook. SaveAs at the beginning and change the FileName to whatever you want, then when you do your Saves later in the code they will rename the file to what you would like.

Show 8 more comments. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Stack Gives Back Safety in numbers: crowdsourcing data on nefarious IP addresses.

Featured on Meta. New post summary designs on greatest hits now, everywhere else eventually. Related Helpful resources. SBX - Ask Questions. Community Forums. Ask a question. Personalize your experience! Personalized Community is here! Less than 24 hours ago you accepted the answer that has this link in its content! I posted this before, but you may not have read it. Seriously, since you're just beginning in Python, it might be a good idea to look through a tutorial and learn the basics of the language, rather than try to learn just the features you need and search for the answers on StackOverflow when you can't find something.

It'll take more time, sure, but you'll get a MUCH better understanding of the language. Add a comment. Active Oldest Votes. Improve this answer. Joe Hansen Joe Hansen Use csv. You can close files not csv. Waqas Waqas 3, 27 27 silver badges 17 17 bronze badges. You can save it as follow if you have Pandas Dataframe df.

Was this information helpful? Yes No. Thank you! Any more feedback? The more you tell us the more we can help. Can you help us improve? Resolved my issue. Clear instructions.