+ Reply to Thread
Results 1 to 3 of 3

Save As Macro

  1. #1
    Registered User
    Join Date
    02-24-2004
    Posts
    21

    Save As Macro

    If users are using an Excel template, is it possible to get the SaveAs box to open through a macro?

    Deb

  2. #2
    Forum Contributor
    Join Date
    01-11-2004
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    388
    Hi!

    Yes: can be done through VBA.
    A call such as :

    fname = Application.GetSaveAsFilename

    will bring up the dialogue box which deals with "Save as"

    See GetSaveAsFilename in Visual Basic Help.

    Alf

  3. #3
    Registered User
    Join Date
    02-24-2004
    Posts
    21
    Thanks. That worked well.

    Deb

+ 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