View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
lee lee is offline
external usenet poster
 
Posts: 184
Default Svae file within macro

How do I save a file automaticaly with a variable file name. Eg I want to
save a file twice a day at the end of each shift (info to be contained within
an established macro) with the date as a file name with am or pm added to the
end to signify which shift the info is from.

Can anyone help please???