| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 'Save as' window in VBA | Excel Discussion (Misc queries) | |||
| how to save a desired window size but hv window comeup fullsz by d | Excel Discussion (Misc queries) | |||
| Save As Window Size | Excel Discussion (Misc queries) | |||
| Add favorites to "Save" window | Setting up and Configuration of Excel | |||
| hiding / displaying the excel application window | Excel Programming | |||
Hybrid Mode
