vba code to edit a csv file in notepad and replace data

Hi,

I create a .csv file via a macro using multiple excel files. Once created (file is used for import to a system) I need to edit the file in notepad, replacing commas with semi colons. The file then needs to be re saved as a .txt file.

I can open the file in notepad via vba (Workbooks.OpenText Shell("Notepad.exe " & filename,1) , but am unsure on how to replace the data.

Any help will be greatly appreciated!