| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Call the Save As dialog
Cheers
"Bob Umlas" wrote: ans = Application.GetSaveAsFilename(filefilter:="*.xls, *.xls") This won't save the file, but will place the file name & path in the variable Ans. Then you can save it via Activeworkbook.SaveAs ans "cdb" wrote in message ... I have a macro that copies data from one spreadsheet into a new workbook. At the end I want to call the Save As dialog for the user to enter a file name and save straight away. I know this is probably dead easy, but I just can't get it working. cdb |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| autofilter dialog boxes - can i call this up in the | Excel Worksheet Functions | |||
| how to get disk icon on save button of save as dialog like 2000 | Excel Discussion (Misc queries) | |||
| Call a program from Save As dialog | Excel Programming | |||
| Getting hWnd for API call or Color choosing dialog | Excel Programming | |||
| Why system asks me to save change even after I call save method(VB.NET) | Excel Programming | |||
Threaded Mode
