-
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.
Last edited by GillsITWorld; 05-25-2020 at 10:35 AM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules