+ Reply to Thread
Results 1 to 2 of 2

If workbook path is specific directory then prompt user to save file

  1. #1
    Forum Contributor
    Join Date
    08-08-2015
    Location
    North Carolina USA
    MS-Off Ver
    MS Office 2016
    Posts
    368

    If workbook path is specific directory then prompt user to save file

    Hi - I am trying to figure out the code to check the filepath of the open workbook and if it is "U:\Hearings\Hearings\" then open an "OK" msgbox saying "Please save this file to another location" - and then after OK is pressed, open the save as location prompt.. preferably to desktop.. although, each person opening this workbook will have a different username... (i.e C:\users\johndoe\Desktop)

    I know this is relatively simple... but wasnt working when I tried using several variations of

    If ActiveWorkbook.Path = "U:\Hearings\Hearings\" Then _
    MsgBox vbOK


    The actual file path is U:\Hearings\Hearings (and then the document is saved in the second "hearings" folder

    Thanks!

  2. #2
    Forum Contributor
    Join Date
    08-08-2015
    Location
    North Carolina USA
    MS-Off Ver
    MS Office 2016
    Posts
    368

    Re: If workbook path is specific directory then prompt user to save file

    Sorry - just realized I needed to remove a \ - haha sorry for the trouble!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Prompt user to locate a file to then be saved to predetermined directory
    By Ethanrholt in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-04-2015, 09:01 AM
  2. [SOLVED] Need to loop a macro to save images to file - but save to user defined directory.
    By superfurry in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-19-2015, 07:49 AM
  3. Save file with specific name and ask user for the path
    By kammariarun in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-08-2013, 05:19 PM
  4. Call in Variable File Directory and Filename from Cell into Save As Prompt
    By cyphus64 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-08-2013, 09:37 PM
  5. Replies: 0
    Last Post: 01-27-2013, 12:13 PM
  6. Replies: 2
    Last Post: 01-16-2013, 03:10 PM
  7. Replies: 3
    Last Post: 06-11-2009, 07:08 PM

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