+ Reply to Thread
Results 1 to 5 of 5

auto select file

  1. #1
    Registered User
    Join Date
    06-27-2018
    Location
    America
    MS-Off Ver
    2007
    Posts
    30

    auto select file

    My macro, allows me to choose what folder I want to open, and then select a file. It copys and pastes the information I want from the file to my active workbook.

    Is there a way to choose what folder you want to open and the macro chooses which file to open, to copy and paste information from, based on a partial title?

    The folder is variable so I have to choose it.

    for example the files would look like this:

    abc1date
    abc2date
    abc3date

    So the partial title would just be "abc1" or "abc2"

    this is the code I have right now:

    Please Login or Register  to view this content.

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    5,282

    Re: auto select file

    https://stackoverflow.com/questions/...rtial-filename

    https://www.mrexcel.com/forum/excel-...ile-names.html

  3. #3
    Forum Guru
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    7,408

    Re: auto select file

    Please Login or Register  to view this content.

    Or:-

    Please Login or Register  to view this content.
    Last edited by mehmetcik; 07-18-2018 at 02:01 PM.
    Please Avoid Joining My List Of Blocked Users by:

    Saying Please and Thank you.

    Making requests not demands.

    Checking back on your post. I will not edit any post after 4 days.

    Marking threads as closed once your issue is resolved. How? The tools at the top

    Any reputation (*) points appreciated. None of us gets paid here.

    If you found someone's input useful, please take a second to click the * at the bottom left to let them know

  4. #4
    Registered User
    Join Date
    06-27-2018
    Location
    America
    MS-Off Ver
    2007
    Posts
    30

    Re: auto select file

    Hi, I am still having difficulty. The first code keeps saying, "run time error 424 object required". The second one doesn't seem to work either :/

  5. #5
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    12,222

    Re: auto select file

    @Logit, please read rule #13 of the forum rules.

+ 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