Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
For anyone interested, the solution to my problem was:
ThisWorkbook.VBProject.VBComponents("mControl").Co deModule.Find("(Calculate|PrintOut)", 1, 1, -1, -1, True, , True) This code will return True if "Calculate" OR "PrintOut" is found in mControl module. Information about Regular Expression Syntax can be found at: <http://msdn.microsoft.com/library/default.asp?url=/library/en-us/script56/html/ab0766e1-7037-45ed-aa23-706f58358c0e.asp Paul Martin wrote: Hi Bob Thanks for your reply. It appears to me that your suggested code is a long-winded way of coding something that Excel VBA already automates. The Find method has a PatternSearch argument. My problem is that I don't know the syntax for the pattern search. I've been looking elsewhere on MSDN (haven't got the answer yet) and I was hoping someone here knew the syntax. Regards Paul |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Get rid of with regular expressions | Excel Discussion (Misc queries) | |||
Regular expressions in VB | Excel Discussion (Misc queries) | |||
Regular expressions | Excel Programming | |||
Regular Expressions in VBA? | Excel Programming | |||
VBA and Regular expressions | Excel Programming |