+ Reply to Thread
Results 1 to 3 of 3

VB Code to open excel files in a loop

  1. #1
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    VB Code to open excel files in a loop

    Hello:

    Please refer to attached file.

    I need VB Code to create a loop to open the file names listed in Cell J9 down.
    The location of the file will be in C:\Temp\
    The PW for all files will be "ABCDEFG".

    I have other code which i will add within the loop.

    Let me know if you have any questions.
    Thanks.

    Riz
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    02-12-2011
    Location
    The Netherlands
    MS-Off Ver
    365
    Posts
    817

    Re: VB Code to open excel files in a loop

    Hello Riz,

    With something like this:

    Please Login or Register  to view this content.
    Kind regards, Harry.

  3. #3
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    Re: VB Code to open excel files in a loop

    Hi HSV:

    Thanks a lot, this should work for me.
    Will let you know if further help is needed with this.
    Riz

+ 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. Open multiple files and copy data is slow, code after end of loop not working - help?
    By hadamhiram in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-16-2014, 11:52 PM
  2. Detect attempt to switch between open excel files (windows) during loop
    By lahansen2 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-02-2014, 03:10 PM
  3. Loop to open excel files in a folder
    By elmarko123 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 06-02-2010, 12:58 PM
  4. Code to open multiple excel files
    By mmf in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-31-2008, 05:40 AM
  5. Loop through ".DAT" files, open run code, close next
    By Les Stout in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-20-2006, 05:20 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