Posted to microsoft.public.excel.programming

Paul Martin Paul Martin is offline

external usenet poster

Posts: 114

.CodeModule.Find AND PatternSearch (using Regular Expressions)

Hi all

I am looping through multiple files and scanning the code modules for
the use of "Calculate" OR ".PrintOut" in code.

I'm not sure how to use the Regular Expressions in the PatternSearch
argument of Workbooks(i).VBProject.VBComponents.CodeModule.Fin d to
include the search of these substrings. Any suggestions?

Thanks in advance

Paul Martin
Melbourne, Australia

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Get rid of with regular expressions	Howdy	Excel Discussion (Misc queries)	1	January 18th 10 07:42 PM
Regular expressions in VB	FiluDlidu	Excel Discussion (Misc queries)	4	March 21st 08 01:10 AM
Regular expressions	JeffMelton	Excel Programming	2	March 1st 06 12:52 AM
Regular Expressions in VBA?	Rob[_23_]	Excel Programming	13	February 10th 05 05:34 AM
VBA and Regular expressions	Friedrich Muecke	Excel Programming	3	October 3rd 03 01:46 AM

All times are GMT +1. The time now is 06:03 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us