| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HOW SHOULD I IMPORT & PASTE ONLY THE REQUIRED DATA | Excel Discussion (Misc queries) | |||
| How to import data from a password protected Access DB into Excel. | Excel Discussion (Misc queries) | |||
| import data to specific columns | Excel Discussion (Misc queries) | |||
| Import Data Keeps asking for Password | Excel Discussion (Misc queries) | |||
| import select data from another workbook | Excel Worksheet Functions | |||
Hybrid Mode
