VBA Macro to Open all .txt files in folder in Notepad, from Notepad save as CSV with same filename

[Angelique_C]

Hi,

Can anyone point me in the right direction - I need to run a macro to open all .txt files within a folder, but they need to open in Notepad, then save from Notepad as a csv to a new folder but with the same file name.

any suggestestions would be very much appreciated

 

[Hui]

Why open then in notepad
You may be better off opening them in Excel and save as a CSV

Can you paste 2 typical files?
Are the file structures all the same

 

[Angelique_C]

The CSV files need to be batch loaded into a database, these files were originally exported as a word file, the batch load is imported back as a csv but when importing back - it only works when the word doc has first been copied to notepad, saved as .txt then saved from notepad as a csv... not sure why but am needing to automate the whole process as it is very labour intensive. Here is a sample doc file - the "Upload a File"option would not see the .txt file?;

 

[Hui]

Should the commas go where the | characters are ?

what about the header paragraph, does that get exported or ignored?

Can you start a conversation with me and attach a text file there
it is quite possible that saving as a text file from word is saving in a different format to the original files you have

 

[Hui]

I just dragged this text file here and it works ?
Try dragging the text file here instead of using the paper clip?