Question Re: Excel VBA list all files in a folder & subfolder

Hi, well that seems to have nailed it with one small issue

although the ' has been removed from Wd.Close, it is still asking for me to confirm the save As

i have to cancel the docs it opens any ideas

Replace the wd.Close with wd.Close (0) to get rid of the Save As.

You can add Application.ScreenUpdating = 0 at the begining of the sub to speed things up. Make sure you also add Application.ScreenUpdating = 1 at the end of the sub if you do this. The screen will not show the progress until the macro finishes.

Also add wdapp.quit just before Set wdapp = Nothing in the other sub.

where can I find documentation on Formula= and the file properties?
I am also curious how you show how many records have been added to the spreadsheet.

, well thanks for the assist on this, it works a charm and has saved a lot of work
i have managed to correctly catalogue over 8,250 word files into their correct groups for correspondance reply, it helped alot

fancy earning another donation

That's good, glad to help.