Thread: GREP in VBA
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default GREP in VBA

A quick google search turned up many hits for windows and DOS versions of
GREP.

--
Regards,
Tom Ogilvy


"Gary's Student" wrote in message
...
Thanks for your reply. I may be forced to look at the C code for GREP.
Sadly i suspect that,in this case, plagerism is no less work than doing it
myself.

Thanks again
--
Gary's Student


"JE McGimpsey" wrote:

Don't know if there are any VBA implementations of grep, but if you're
using MacXL, you can take advantage of MacOS being Unix-based to use the
built-in MacScript() method to run an Applescript string which calls the
Unix shell: do shell script "grep expr file", e.g.:

Dim str As String
str = MacScript("do shell script ""egrep 'ab|cd' fname""")

In article ,
"Gary's Student" wrote:

Does any one know of an implememntation of the UNIX GREP command in

Excel
VBA? I need to interpret GREP commands and perform any required file

piping.