Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
When I type out FIND....it find the word, but if I put it in a batch file, it
doesn't come up with an answer. Is there any difference between regular DOS and the window of DOS in that regard? |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
There shouldn't be. Perhaps the directory being reviewed is different in
each instance. -- Regards, Tom Ogilvy "denny" wrote in message ... When I type out FIND....it find the word, but if I put it in a batch file, it doesn't come up with an answer. Is there any difference between regular DOS and the window of DOS in that regard? |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Not that I'm aware, but if you're using the old DOS command to search through
excel files, you probably won't get what you expected. On the other hand, if you save your data as a text file (*.csv), it might work the way you want. denny wrote: When I type out FIND....it find the word, but if I put it in a batch file, it doesn't come up with an answer. Is there any difference between regular DOS and the window of DOS in that regard? -- Dave Peterson |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I finally discovered after I succeeded in closing the txt file by saving it
as an .xls file...I noticed that it was cutting of part of my text (in my big cells)...so FIND wouldn't find it. Then I tried saving it as .cvs and the whole text was preserved and found. It still is not working when I try to search 2 strings at once, but I will try a little more. I just wanted to let you know how this answer led me to another step of success. "Dave Peterson" wrote: Not that I'm aware, but if you're using the old DOS command to search through excel files, you probably won't get what you expected. On the other hand, if you save your data as a text file (*.csv), it might work the way you want. denny wrote: When I type out FIND....it find the word, but if I put it in a batch file, it doesn't come up with an answer. Is there any difference between regular DOS and the window of DOS in that regard? -- Dave Peterson |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I've never saved a text file as .xls, so I don't have a guess.
denny wrote: I finally discovered after I succeeded in closing the txt file by saving it as an .xls file...I noticed that it was cutting of part of my text (in my big cells)...so FIND wouldn't find it. Then I tried saving it as .cvs and the whole text was preserved and found. It still is not working when I try to search 2 strings at once, but I will try a little more. I just wanted to let you know how this answer led me to another step of success. "Dave Peterson" wrote: Not that I'm aware, but if you're using the old DOS command to search through excel files, you probably won't get what you expected. On the other hand, if you save your data as a text file (*.csv), it might work the way you want. denny wrote: When I type out FIND....it find the word, but if I put it in a batch file, it doesn't come up with an answer. Is there any difference between regular DOS and the window of DOS in that regard? -- Dave Peterson -- Dave Peterson |
#6
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Try findstr for your search. Of course findstr /? at the prompt will give you
all the how to use info. Hal "denny" wrote: When I type out FIND....it find the word, but if I put it in a batch file, it doesn't come up with an answer. Is there any difference between regular DOS and the window of DOS in that regard? |
#7
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
This much works for me
find "%1" /I c:\mydocu~1\findtest.txt c:\mydocu~1\found2.txt ....but when I try adding "%2" the end ( c:\mydocu~1\found2.txt) seems to block it |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
HOW DO I FIND A FILE WHEN SHORTCUT DOES NOT WORK | Excel Discussion (Misc queries) | |||
Would Like to Automate Batch File Creation and Text FIle Import | Excel Discussion (Misc queries) | |||
How can I work in excel 2000 with the find window open? | Excel Worksheet Functions | |||
Find File doesn't work properly | Excel Programming | |||
Cant get my code work. Find file or create it | Excel Programming |