ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Declare RegExp from Vbscript.dll (https://www.excelbanter.com/excel-programming/381288-re-declare-regexp-vbscript-dll.html)

Bob Phillips

Declare RegExp from Vbscript.dll
 

Dim RegEx As Object
Set RegEx = CreateObject("vbscript.regexp")

etc.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"TimD" wrote in message
...
I want to use the vbscripting RegExp without going to ToolsReferences.

I would like to know the syntax to use the declare function. My attempt at
it gave me an error asking for the enrty point which I know is 3. I just
don't know how to write it.

Declare Function RegExp Lib "vbscript" ()

Any help would be appreciated.

TimD





All times are GMT +1. The time now is 10:03 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com