Results 1 to 5 of 5

xlDialogSaveAs

Threaded View

sighlent1 xlDialogSaveAs 03-14-2011, 10:28 AM
MarvinP Re: xlDialogSaveAs 03-14-2011, 10:58 AM
sighlent1 Re: xlDialogSaveAs 03-14-2011, 11:04 AM
royUK Re: xlDialogSaveAs 03-14-2011, 11:05 AM
sighlent1 Re: xlDialogSaveAs 03-14-2011, 11:15 AM
  1. #1
    Forum Contributor
    Join Date
    02-11-2009
    Location
    Montclair, NJ
    MS-Off Ver
    Excel 365
    Posts
    236

    xlDialogSaveAs

    Hey,

    I have these 2 macros that work perfectly fine separately, but I'm having a difficult time trying to combine them to being 1 macro

    The one makes a dialog box pop up that makes the "Save as file type" a Macro Enabled Workbook

    Sub SaveAsDialog()
        
        Application.Dialogs(xlDialogSaveAs).Show sFilename, xlOpenXMLWorkbookMacroEnabled
    End Sub
    And this macro saves the file to a certain location on my computer

    Sub Auto_Open()
        Application.GetSaveAsFilename "C:\Documents and Settings\bob\Desktop\Excel\"
    End Sub
    Any ideas on how to combine these files?

    Thank you, as always, I really appreciate your time and efforts,
    Bob
    Last edited by sighlent1; 03-14-2011 at 11:16 AM.

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1