Hi

I want to create a macro that Saves the workbook with the value of
cell.. However I want the user to be able to choose the destination
but not the filename.

How can I do this?

And it would also be great to set a defult save folder for the user.
i.e. When the user saves the document through my macro, it then save
the chosen destination folder, and stores this for next time the macr
runs...
So next time he wants to save, it automatically chooses this folder..

--
Ctec

-----------------------------------------------------------------------
Ctech's Profile: http://www.excelforum.com/member.php...fo&userid=2774
View this thread: http://www.excelforum.com/showthread.php?threadid=52955