Hello!

Here is the premise of what I have going on. I have a batch script that needs to verify if a username is found in an excel file or not. Currently I have this script here to convert the excel sheet to txt so its searchable.

Please Login or Register  to view this content.
And that has been working fine for a long time. The excel file contains a lot of additional data other than the username's and I've found 1 user whos username is short (hlee) and is not in the list. However his username is found in other names like Kathleen so its showing false positives.

I need a way to clear all the columns except for column E before it converts to txt.
My other issue is the excel file gets created and uploaded to a fileshare every morning so I have no way to prune it or insert a macro at the source before its uploaded.

I have this macro which works but I need a way to insert it into the first script before it converts the file to txt. 

Please Login or Register  to view this content.
Is that possible?

Thanks