Auto Import OR Searching TXT Data
 

Is there any simple way to import a file from a TXT file automatically
by clicking a button in Excel. If not is there a way or program to
convert a txt file to excel via batch file? Basically I have this
command:

=IF(COUNTIF(Sheet2!A1:A7969,C8)0,"YES","NO")

This is asking if I enter a number in cell C8 and it equals any number
on Sheet 2 in column A
then return a YES if not NO. However this file changes daily and I
dont want to have to keep reimporting this file every day by hand and
would like it automated basically with either a click of a button or
off the name of a constant spread sheet or TXT file.

Any ideas would be GREAT!!

Auto Import OR Searching TXT Data
 

Answered my own question:
Just in case anyone is curious how I did this...

Noticed that if you rename the ***.txt to ***.cvs it will put in XLS
format
Took txt file in batch file and renamed. Used the new spread sheet
name in place of
Sheet2 and the whole column. Placed this is a folder on the server and
just attached
a short cut to desktop and used link to batch file to run inside excel
to update each time.

=IF(COUNTIF(ExTRTbl.csv!$A:$A,C8)0,"Yes","No")

This was my fast work around... but if anyone else knows of a better
way? Please post.