+ Reply to Thread
Results 1 to 4 of 4

Need some help with a macro to open specific folder

  1. #1
    Forum Contributor
    Join Date
    12-11-2014
    Location
    Missouri
    MS-Off Ver
    2016
    Posts
    153

    Need some help with a macro to open specific folder

    Hi Everyone,

    I have the macro below on a button in a worksheet and I want it to open "C:\Users\HOME\Dropbox\DSR DAILY IMPORT\" so we can select a file
    which it does BUT it also opens "My Documents" folder as well? I'm not seeing why that is happening?

    Thank you!

    Please Login or Register  to view this content.

  2. #2
    Forum Expert JLGWhiz's Avatar
    Join Date
    02-20-2011
    Location
    Florida, USA
    MS-Off Ver
    Windows 10, Excel 2013
    Posts
    2,070

    Re: Need some help with a macro to open specific folder

    Probably because the workbook you are running the code from is in the 'My Documents' folder. On many systems the 'My Documents' is in the default path for opening and saving files.
    Any code provided by me should be tested on a copy or a mock up of your original data before applying it to the original. Some events in VBA cannot be reversed with the undo facility in Excel. If your original post is satisfied, please mark the thread as "Solved". To upload a file, see the banner at top of this page.
    Just when I think I am smart, I learn something new!

  3. #3
    Forum Contributor
    Join Date
    12-11-2014
    Location
    Missouri
    MS-Off Ver
    2016
    Posts
    153

    Re: Need some help with a macro to open specific folder

    JLGWhiz,

    Thanks for the reply. The Workbook is actually located in C:\OFFICEELITE so I'm still missing something here?

    Thanks!

  4. #4
    Forum Expert JLGWhiz's Avatar
    Join Date
    02-20-2011
    Location
    Florida, USA
    MS-Off Ver
    Windows 10, Excel 2013
    Posts
    2,070

    Re: Need some help with a macro to open specific folder

    In the Excel Window, click File>Options>Save and under 'Save Workbooks' see what your default path is. That is the only thing I know would cause the folder to appear open automatically.

+ 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] Macro to list and open .xlsm files in folder and sub-folder
    By Howardc1001 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-24-2019, 07:35 PM
  2. Open folder macro opening wrong folder
    By jomili in forum Word Programming / VBA / Macros
    Replies: 5
    Last Post: 08-23-2018, 09:27 AM
  3. [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
  4. [SOLVED] Macro neede to open text files from folder and remove all the lines except specific lines
    By genetist in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 10-07-2014, 02:44 AM
  5. [SOLVED] Macro to open specific folder
    By siobeh in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-16-2013, 04:22 PM
  6. [SOLVED] Open specific folder, select file to open and copy then paste
    By Kranky in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-22-2012, 12:14 AM
  7. Macro to Open specific files in a Folder
    By lorena.tgarza in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 11-15-2012, 09:01 AM

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