Announcement

Collapse
No announcement yet.

Unconfigured Ad Widget

Collapse

Open save as dialog box using macro.

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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.

  • #2
    Re: Open save as dialog box using macro.

    Do you mean this?

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

    Matt
    Matt B

    Comment


    • #3
      Re: Open save as dialog box using macro.

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

      Roy

      New users should read the Forum Rules before posting

      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.

      Comment


      • #4
        Re: Open save as dialog box using macro.

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

        Comment

        Trending

        Collapse

        There are no results that meet this criteria.

        Working...
        X