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
|