Assuming this hasn't been moved to the other forum as seems imminent

You don't need what he suggested if you use .SaveAs as you've shown. Test your code. You wiill see that it stops and presents the dialog you want with the .SaveAs command.

It looks like you set it up right too.