View Single Post
 
Old 10-15-2014, 09:03 AM
subspace3 subspace3 is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Oct 2014
Posts: 8
subspace3 is on a distinguished road
Default Macro help regex

Hi all,

Using bits from

http://vba-tutorial.com/recursive-di...x-file-search/

And bits from another page I've managed to put together a macro that does a recursive search in a path and batch convert word docs to html. When I'm home ill find the code and paste it here to see what you think needs improving.

I'm totally new to this but modifying certain aspects seems like common sense to me.

Anyway, in wanting to not select test.docm in the expression and then process all other documents ending in docx/ docm.
Now for docm/x works ('.*doc[mx]') but the problem is, it includes the macro document itself which is called test.docm.

So it converts that to html, and then closes the active document, this not processing any other documents.

I've tried '(!test.docm) .*doc[mx]' but I'm probably way off.

Any ideas guys?
Reply With Quote