Save As dialog box in macro

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Dennis (dvlasich_at_askerry.com)
Date: 06/24/04 

Date: Thu, 24 Jun 2004 14:41:17 -0700

Last week I learned how to invoke a FileOpen dialog box
in a macro so that the filename could be inserted at
runtime. I need to do the opposite now--bring up a Save
As dialog box to let the user navigate and enter a file
name. Where can I find the code to do this?

Relevant Pages

  • Re: Caching?
    ... And regardless of why I changed the filename, ... when I deleted the file altogether, the macro would not finish. ... Filesearch just might return the old-name of a renamed file. ... Public Sub ImportFiles() ...
    (microsoft.public.excel.programming)
  • Re: Help end the testing tedium please
    ... The new macro is crashing at: ... The filename and sheet name look fine. ... two arguments needed for "Consolidate". ... the file really were test1 thru test60, would the array statement need ...
    (microsoft.public.excel.programming)
  • Re: Help end the testing tedium please
    ... You didn't answer my questions as to whether, if a macro bombs, if the stuff ... Look at the utility worksheet in columns G and I like the code below ... The filename and sheet name look fine. ... that question that confuses you on the B = A thing: ...
    (microsoft.public.excel.programming)
  • Re: 64k row limit
    ... Seems it's not the macro, but an EOF character that is causing the hang-up. ... Dim ResultStr As String ... Dim FileNum As Integer ... FileName = Application.GetOpenFilename ...
    (microsoft.public.excel.worksheet.functions)
  • Re: How to insert an image file into Work AND have the file name d
    ... Selection.InsertAfter vbCr & FileName ... There's nothing the macro can do to find out what the others were. ... Picture> From File dialog, multiple-selected pictures don't get ...
    (microsoft.public.word.docmanagement)