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.