Vba screenupdating word
Data Fields("Brand") field indicates which letterhead is used and, hence, the folder the file should be saved to? Hi Macropod, Thanks for letting me know about the code button, I'll use it from now on. Data Fields("Brand") field indicates the type of letterhead to be used, currently the code just lumps all the letters into one shared folder but if there's a way of automatically separating these out into individual folders, that would save a lot of hassle, even more so if there's a way that individual files could be saved, each containing all of the letters for that letterhead/brand.
To work the below code you need to Sub Copy_From_Word() Application.
This can mean that what should take a matter of 1 to 3 seconds, often takes a lot longer.
Free Excel Help One drawback with recorded macros in Excel is that the code produced is often very inefficient.
I have two folders (Letters_1 and Letters_2) each containing over 800 ".doc" files.
Data Fields("Brand") & ".docx" ' ADDED CODE End With . Having run the debugger it's highlighted the following: Sub merge1record_at_a_time() .execute I've attempted it a couple of times and no joy, any ideas? I would like to know if you could kindly help me with this.