View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default 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.