can macro parse multiple excel files
Manage your personal finances in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: can macro parse multiple excel files

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Hi, I wanted to know if it was possible to open up all the excel files within a certain folder and get data from certain columns within each of those files and place that data into one excel file. Assuming you would not know the names of the files within that folder.

    Someone posted a similar question a couple of days ago but didn't get any reply.

    Thanks

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    =ActiveCell.Address
    Posts
    478
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

  3. #3
    New Member
    Join Date
    Apr 2002
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    AJ, thanks alot. I think it's exactly what I am looking for. I haven't tried it yet to see if it would work for me, but it seems very promising. Thanks again.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com