View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tim P. Tim P. is offline
external usenet poster
 
Posts: 1
Default Macros saving files.

I was wondering if there was a way in Excel to batch save
a group of files that are emailed daily through Outlook,
to a previously assigned generic name.

For example, we get reports emailed to us every day (in
Outlook) that replace the same file from the previous
day. Instead of opening each individual file and doing
a "save as", is there a way to run a macro to auto-save
those files to their pre-determined name? Thank you for
your help.

Tim