Results 1 to 7 of 7

Open multiple files from a folder based on cell information?

Threaded View

  1. #1
    Registered User
    Join Date
    09-24-2007
    Posts
    7

    Open multiple files from a folder based on cell information?

    Hi,

    I would like to know how to open multiple excel files from a folder based on the information based in cells down a certain column until the last cell.

    I thought it might be something like this but it isn't:

    Sub OpenFiles()
         
    Dim eFile As String, totalrows As String
         
    totalrows = ActiveSheet.UsedRange.Rows.Count
         
    For row = 2 To totalrows
        
    eFile = Cells(row, 3).Value
        
    Workbooks.Open Filename:=eFile
         
    Next row
    
    End Sub
    I'm still a noob as it shows so any help would be good.

    Thanks
    Last edited by VBA Noob; 10-03-2008 at 08:37 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Import Specific line from multiple text files
    By Vlad999 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-14-2008, 06:50 PM
  2. Replies: 10
    Last Post: 04-05-2007, 12:54 AM
  3. Replies: 2
    Last Post: 11-23-2006, 09:54 AM
  4. Splitting one cell information into multiple
    By Dhruva101 in forum Excel General
    Replies: 9
    Last Post: 10-15-2006, 09:53 PM
  5. Open "ANY" excel files in a particular folder
    By Ayansane in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-26-2006, 12:47 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