Configuring code to pull data from .docm user forms

[samuelle]

Hi I can use the following code successfully to pull userform data from .docx files to Excel but unfortunately I need it to pull from .docm files. I have tried changing the

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

to no avail. Any help would be most appreciated.

Please Login or Register  to view this content.

[Norie]

How is it not working when you change from docx to docm?

[samuelle]

It doesn't give an error message - just does absolutely nothing and doesn't pull anything across.

[Norie]

Have you stepped through the code with F8 to see what's happening, specifically to see if any files are actually being picked up?