R
rmellison
I want to be able to create a macro that quickly collates a set of open
documents into one document. I have a number of live docs that we need to
remain as seperate files, but I regularly need to bring them together as one
report. This is taking longer and longer using copy|paste, especially as the
number of files increases.
My knowledge of VBA is limited at best, so if someone can suggest a macro
that opens each file inturn, copies the contents into a template, then
inserts a section break and new header (filename of the next doc) before
copying the next file, then it would save me hours!
Thanks in advance!
documents into one document. I have a number of live docs that we need to
remain as seperate files, but I regularly need to bring them together as one
report. This is taking longer and longer using copy|paste, especially as the
number of files increases.
My knowledge of VBA is limited at best, so if someone can suggest a macro
that opens each file inturn, copies the contents into a template, then
inserts a section break and new header (filename of the next doc) before
copying the next file, then it would save me hours!
Thanks in advance!