+ Reply to Thread
Results 1 to 2 of 2

Save As Dialog Box - Default Path and File Name, User Selects Sub Folder from Default Path

  1. #1
    Registered User
    Join Date
    12-11-2012
    Location
    Madison, WI
    MS-Off Ver
    Excel 2010
    Posts
    3

    Question Save As Dialog Box - Default Path and File Name, User Selects Sub Folder from Default Path

    What I Need:

    A Save As dialog box to open to a default path with the current workbook name as the default file name. It can't automatically save because once the default path opens, the user will need to select the appropriate sub-folder based on a set of criteria that is constantly changing (the sub-folders are named with a date range of when they will be "open" for new submissions ... the dates don't exactly have a logical structure behind them).

    What I Have:

    Please Login or Register  to view this content.
    What It's Doing:

    The macro opens the Save As dialog box to the appropriate folder, but there is no workbook name automatically entered - to avoid as much human error as possible, I would really like this to default to the name the workbook is already saved under.

    Thank you in advance for your help!

    Christen

  2. #2
    Registered User
    Join Date
    12-11-2012
    Location
    Madison, WI
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Save As Dialog Box - Default Path and File Name, User Selects Sub Folder from Default

    I've found the answer to my problem via a different forum thread. For any having the same issue, this was the solution:

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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