Thread: closing file
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
JLGWhiz[_2_] JLGWhiz[_2_] is offline
external usenet poster
 
Posts: 1,565
Default closing file

ActiveWorkbook.Close



"Novice Lee" wrote in message
...
Hello,

I have a module that sorts data for me. part of the code opens a source
file
then saves it to another directory with todays date and adds a number to
it
it there is another file with that same name.
my question is how can i close the save as file,

Thanks