+ Reply to Thread
Results 1 to 4 of 4

Macro that goes to Folder, selects- not open- files specified

  1. #1
    Registered User
    Join Date
    04-24-2014
    Location
    Glendale, Colorado
    MS-Off Ver
    Excel 2013
    Posts
    49

    Macro that goes to Folder, selects- not open- files specified

    I need a macro that opens Windows Explorer, goes to a folder and selects multiple files based on filenames either on my clipboard or excel. The files named may be in different subfolders within the main folder, the macro should look in there, too. Sometime volume is quite high; over 10k files.

  2. #2
    Valued Forum Contributor ranman256's Avatar
    Join Date
    07-29-2012
    Location
    Kentucky
    MS-Off Ver
    Excel 2003
    Posts
    1,176

    Re: Macro that goes to Folder, selects- not open- files specified

    There is code to look at files in folder...then do what... open all 10k of them in Excel?
    Are these excel files or other?

  3. #3
    Registered User
    Join Date
    04-24-2014
    Location
    Glendale, Colorado
    MS-Off Ver
    Excel 2013
    Posts
    49

    Re: Macro that goes to Folder, selects- not open- files specified

    Not open, just select them. They are pdfs, jpegs and tifs

  4. #4
    Registered User
    Join Date
    04-24-2014
    Location
    Glendale, Colorado
    MS-Off Ver
    Excel 2013
    Posts
    49

    Re: Macro that goes to Folder, selects- not open- files specified

    ranman256-
    Can you look at below screencast? I get an error after I paste the macro...
    http://youtu.be/cRjL1hK20fY?hd=1

+ 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 open folder on desktop and certain files within
    By hutch94 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-05-2014, 11:01 AM
  2. [SOLVED] macro to open all files in a folder, save them, then close them
    By hopefulhart in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-27-2013, 06:40 PM
  3. 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
  4. Macro to open up all files in certain folder
    By dpcp in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-06-2012, 03:26 PM
  5. [SOLVED] Excel macro to open files within a folder
    By Craig in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-08-2005, 04:05 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