View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default Changing Path for SaveAs Functions

Post the macro for us to see.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Rick B" wrote in message
...
Hello
I am trying to write code that automatically saves a file. Everything
works
fine until I copy and paste the file in another folder. When the macro
saves
the file it automatically defaults to the original location (where the
code
was originally written)and not the folder in which it is currently in.
How do I change this, without being specific to a drive or folder?

I have posted 1 other time in the past and the help i recieved was right
on,
first time. I appreciate any help I can get.

Thanks in advance,
--
Rick B