Save WB with vba on some location

[ninny_]

I have code to save wb and mail it.
But often hapens that workbook saves on the last location that i saved something, and i want it to be saved in my documents no matter do i work with that WB or someone else on some other computer..
Please help if someone knows what is wrong with code...

Please Login or Register  to view this content.

[davesexcel]

Please Login or Register  to view this content.

[ninny_]

It works great.. thank you very much !!!

[ninny_]

He.. but now i got a new problem...
Makes a copy of the wb on the right place, but doesn´t mail it...actually it doesn´t create a new e-mail with the attachment in it.