View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Muxer[_2_] Muxer[_2_] is offline
external usenet poster
 
Posts: 2
Default Adding file name and path to to footer of all workbooks in a folder.

Hello,

Can anyone show me some examples of how to add the file name and path of
workbook to the footer. I would like to do this to all *.xls files in a
folder.

Since at times there is going to be hundreds of files, is it fastest
and/or easier to do this via an add-in, macro or from VB6?

Regards,
LRR