Keep original file path when I copy a sheet into a new book

Hello,


Currently I have a problem when I open an excel file, I have to copy a sheet into a new Book then when I want to save my new book with 'save as' the new open dialog is on my "default location" option and not the path file of my original sheet....


IE :

I open : c:\job\2013\Client\Operation\jan\myfile.xls
I copy sheet1 in my new book
I want to save as but open dialog is on C:\Users\Me\Documents... and I want this path c:\job\2013\Client\Operation\jan\


Can you help me? I'm losting too much time...



Best regards