vba: Edit very big file without uploading in excel

My file is big with 10 million rows
I want to accomplish Find and replace multiple sting operations
Can this be done in vba without uploading in excel?
Then save the edited file in asked folder name ?

There isn't a whole lot of information given but this should be possible with a custom script. I've written similar scripts in C# but you can with VBA as well to access your file and adjust the data.

Again, without knowing what type of file it is and what you want done specifically, it is a very broad question to answer.

Its a text file !!

I am only posting this as a demonstration that this can be done. I am by no means stating that this will work for anything other than my small test I have done with the code.

- It will ask for the source file path
- It will ask for a full path for the output file it's going to create
- It will ask the string you want to find. I used "test"
- It will ask the string you want to replace it with. I used "TEST"
- It will ask you if there's a delimiter between data in the rows
- It will process the data until it's done. (I was too lazy to add any error checking which is the reason for the disclaimer below)

VERY BIG DISCLAIMER: USE AT YOUR OWN RISK
If you want to test this, I suggest copying the file and run the test on a duplicate so the original remains unaffected.

Macro:

Please Login or Register  to view this content.

Input File:

Please Login or Register  to view this content.

Output File:

Please Login or Register  to view this content.