View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kevin McLean Kevin McLean is offline
external usenet poster
 
Posts: 3
Default VBA Code to automate "Save As"

I would like to use a "Save As" VBA code to save a file
already open to another drive location. An example of my
code is below. Everytime this code runs it asks for
confirmation "yes/no" if I'd like to override the existing
file. I will always want to override it and would like a
line of VBA code to take care of that. Any ideas?

Thank you so much!

Kevin