Changing default folder for SaveAs dialogue

[beeawwb]

Hi everyone. I've got an issue with an excel worksheet I'm making up.

Essentially, I've got a list of cells which combine to make a filename. I add these to the directory name which is also made up of cells.

Eg (not my exact code)
sDirectory = "G:\PinUser\PinDept\Procurement\"
sUser = .Cells(9,5)
sFinalDir= sDirectory & "\" & sUser
sFilename= sFile & ".xls"

So, it's all well and good if I want to just use ActiveWorkbook.SaveAs (once I've combined the directory and file name), but what I really want to happen is this.

The Save As dialogue appears, with sFilename as the default filename, and sFinalDir as the default folder to save as. Because really, I want the user to have to confirm the filename suggested, and the folder they're saving in to. If it wasn't for the user having choice, I'd be fine!

Any suggestions on how to do what I'm wanting?

Thanks in advance,

Robert.

[Carim]

Hi,

Believe the solution is to insert a Msgbox where the default directory appears so that the user has the possibility either to accept it or to modify it ...

HTH
Carim