Results 1 to 2 of 2

Thread: Importing many files

  1. Oct 20th, 2005, 09:03 AM #1
    sveegaard
    sveegaard is offline

    Thread Starter
    Addicted Member
    Join Date
    Jul 2005
    Posts
    236

    Exclamation Importing many files

    Hi all,

    I want to import all files from a directory that I choose, to Excel. How can I define which files (in this case all files) in a directory, eventually by using a listbox?

    Regards,

    sveegaard
    Reply With Quote Reply With Quote
  2. Oct 20th, 2005, 09:13 AM #2
    DKenny
    DKenny is offline
    Frenzied Member DKenny's Avatar
    Join Date
    Sep 2005
    Location
    on the good ship oblivion..
    Posts
    1,171

    Re: Importing many files

    Search the VBA help for the DIR function. It has lots of examples of looping through the files in a directory.
    Declan

    Don't forget to mark your Thread as resolved.
    Take a moment to rate posts that you think are helpful
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width