+ Reply to Thread
Results 1 to 6 of 6

Open folder macro opening wrong folder

  1. #1
    Valued Forum Contributor
    Join Date
    12-02-2009
    Location
    Austin, Tx
    MS-Off Ver
    Office 365 64-Bit, 2108, build 14326.21018
    Posts
    3,952

    Open folder macro opening wrong folder

    From time to time my tried and trusty "Open folder" macro doesn't work correctly. I show two variations below, both of which have the same problem. The idea is to open the folder the active document is in. Most times the macro works fine, but sometimes, like for the last two days, it consistently opens the "My Documents" folder, when the document is in a remote folder that I have rights to. I'd appreciate it if someone can tell me what's going on.
    Please Login or Register  to view this content.
    I know I'm not stupid, but I suspect I'm a lot stupider than I think I am

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,883

    Re: Open folder macro opening wrong folder

    My guess is that some network issue is causing this.
    i.e. network drive path isn't available when the code runs, so it defaulted to Word's default path location (which is usually set to My Documents folder).
    ?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
    ― Robert A. Heinlein

  3. #3
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: Open folder macro opening wrong folder

    Has the document ever been saved?
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

  4. #4
    Valued Forum Contributor
    Join Date
    12-02-2009
    Location
    Austin, Tx
    MS-Off Ver
    Office 365 64-Bit, 2108, build 14326.21018
    Posts
    3,952

    Re: Open folder macro opening wrong folder

    Oh yes, all of these documents have been saved many times. Going to CK76 comment about network issues, I can see how that would interfere, but I don't see any issues with the drive. It's still very accessible.

  5. #5
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,883

    Re: Open folder macro opening wrong folder

    Hmm, only other thing that comes to mind is auto-backup and/or offline sync. But if the code has been working for while...
    Don't think that would be the cause.

  6. #6
    Valued Forum Contributor
    Join Date
    12-02-2009
    Location
    Austin, Tx
    MS-Off Ver
    Office 365 64-Bit, 2108, build 14326.21018
    Posts
    3,952

    Re: Open folder macro opening wrong folder

    And of course today everything is working as it should. Maybe it's Wednesdays that are at fault?

+ 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] Excel VBA code for selecting a folder then search & open specified files in that folder
    By Excelrookie_1 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-27-2021, 03:09 AM
  2. [SOLVED] Open newest folder and specific file in the folder
    By timtim91 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-09-2017, 11:55 AM
  3. [SOLVED] Specific folder when opening windows popup folder selection with msoFileDialogFolderPicker
    By trizzo in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-18-2015, 11:05 AM
  4. Open Folder (Prompt User for final folder name in location path)
    By synergeticink in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-21-2014, 03:33 PM
  5. Macros Open folder, copy, paste and close the folder
    By hahahahahahaha in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-10-2013, 05:03 PM
  6. [SOLVED] What is wrong with this code? (Loop through WBs in folder - open, edit, save & close)
    By mc84excel in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-04-2013, 07:49 PM
  7. [SOLVED] whats wrong with this code: need to open picture from folder in IE
    By Lkivagten in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-01-2012, 05:32 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