Save As a specified path and one suggested filename

[Gamla kläder]

Hello boys and girls

I need a macro that says.

1. Shows the dialog box "Save as"
2. Suggest the path from cell "Q7"
3. Suggest the filename from cell "Q8"

I have one code that says:

ActiveWorkbook.SaveAs Filename:=Range("Q7").Value & ".xlsm", FileFormat:=xlOpenXMLWorkbookMacroEnabled

But the problem is that I want myselves to see that it is saved by puch the savebutton on the dialog box, and also a chance to change filename if I want.

Is this even possible?? I would be really greatful

[patel45]

Please Login or Register  to view this content.

[ragulduy]

Please Login or Register  to view this content.

?

[Gamla kläder]

Thanks a lot!!!

This work perfekt for me. Just as I wanted. And what a quick answer, impressed!