My friend has created 458 files in excel & 347 files in word without
inserting footer. I want to insert footer in all these files, but opening
each file and inserting footer is tedious work. Can I insert footer in all
these files with path and filename at one go?
Ajit
--
Knowldege is Power

Try a Word newsgroup.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Ajit Munj" wrote in message
...
My friend has created 458 files in excel & 347 files in word without
inserting footer. I want to insert footer in all these files, but opening
each file and inserting footer is tedious work. Can I insert footer in all
these files with path and filename at one go?
Ajit
--
Knowldege is Power

You could create a macro that would open each of the files, apply the footer to
each worksheet in the workbook and then save the file.

But lots would depend on where the files are, which should be included (all or
just some), and so forth.

I bet you would get the same kind of response in a Word newsgroup.

Ajit Munj wrote:

My friend has created 458 files in excel & 347 files in word without
inserting footer. I want to insert footer in all these files, but opening
each file and inserting footer is tedious work. Can I insert footer in all
these files with path and filename at one go?
Ajit
--
Knowldege is Power

--

Dave Peterson