I'm trying to display the Save As window using VBA. I can display the
window, but when I click on save button, nothing happens. I am assuming it
is possible to do this, and I figure I'm missing something.

In case it makes a difference, I'm using Excel 97.