Import .txt File with normal Space Delimiters
Hello!
I am trying to use a macro so that it will look for this .txt file and open it as a fixed width delimited so that I can have it edit and save as an excel.
.txt = BlankContracts.txt (Wont let me attached says incorrect file, just a .txt file)
So basically I will have an auto scheduler pull up the correct macro enabled excel form, this macro will then look for this file "BlankContracts.txt" on "C:\Users\Gill\Desktop" then open the txt file in excel as a fixed width delimited. Then I want it to search for the word "CONLST" and delete that row and the 4 rows after each time it finds the word.