Displaying the Save As Window using VBA
 

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.

Displaying the Save As Window using VBA
 

That is because it simply the full path and name of the file you selected.
You then have to save it yourself using that returned value.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Dan" wrote in message
...
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.