Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 4 of 4

Thread: Open save as dialog box using macro.

  1. #1
    Join Date
    30th October 2004
    Posts
    43

    Open save as dialog box using macro.

    Dont know whether this is possible or not.
    I want to open save as dialog box by Excel macro.

    Many thanks in advance.

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    4th November 2004
    Location
    London
    Posts
    35

    Re: Open save as dialog box using macro.

    Do you mean this?

    VB:
    Sub opensavedialog() 
         
        Application.Dialogs(xlDialogSaveAs).Show 
         
    End Sub 
    
    
    Hope this helps

    Matt

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    26th January 2003
    Location
    Derbyshire,UK
    Posts
    18,294

    Re: Open save as dialog box using macro.

    Try this
    VB:
    Application.Dialogs(xlDialogSaveAs).Show 
    End Sub 
    
    
    Hope that Helps

    Roy

    For free Excel tools & articles visit my web site

    If I have helped you and you feel like putting your hand in your pocket please make a donation to Children in Need

    RoyUK's Web Site

    royUK's Database Form

    Where to paste code from the Forum

    About me.

  4. #4
    Join Date
    30th October 2004
    Posts
    43

    Re: Open save as dialog box using macro.

    Thank u very much,
    This is exactly what I need.
    Thanks once again.

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Replies: 2
    Last Post: May 10th, 2008, 07:11
  2. Macro To Bring Up Save As Dialog Box
    By Chrome46 in forum EXCEL HELP
    Replies: 11
    Last Post: February 20th, 2007, 06:56
  3. Cant open Macro Dialog Box
    By reciecup2000 in forum Technical Issues Help
    Replies: 3
    Last Post: September 9th, 2006, 23:29
  4. Macro: open all .xl, save, txt
    By highNNdry in forum EXCEL HELP
    Replies: 3
    Last Post: March 22nd, 2006, 09:43
  5. File Open/Save dialog in Access 2000 running on Win98, Win2K
    By zeus in forum Excel and/or Access Help
    Replies: 1
    Last Post: April 18th, 2003, 00:56

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
porno