+ Reply to Thread
Results 1 to 3 of 3

Dialogs(xlDialogSaveAs)

  1. #1
    Forum Contributor
    Join Date
    02-11-2009
    Location
    Montclair, NJ
    MS-Off Ver
    Excel 365
    Posts
    224

    Dialogs(xlDialogSaveAs)

    Hey,

    I'm currently reading a VBA book and this code was listed as and example for the Dialogs

    Please Login or Register  to view this content.
    This code brings up the dialog box to be able to save the workbook as a "Excel 97-2003 Workbook"

    I looked online to see if I could change the "xlWorkbook" part of the code to save it as a Macro-Enabled workbook, but couldn't find anything

    Could someone please help?

    Thank you sooooo much!!!
    Bob
    Last edited by sighlent1; 02-28-2011 at 02:28 PM.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,436

    Re: Dialogs(xlDialogSaveAs)

    Please Login or Register  to view this content.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Forum Contributor
    Join Date
    02-11-2009
    Location
    Montclair, NJ
    MS-Off Ver
    Excel 365
    Posts
    224

    Re: Dialogs(xlDialogSaveAs)

    Excellent, Thank you!!!!!!!!!

+ Reply to Thread

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