MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Process files in a directory

  Asked By: Ernesta    Date: Oct 12    Category: MS Office    Views: 1349

Can anyone help to get me started?
I need to write a VBA prgram that will, upon activating,
prompt for a folder that store the Excel files to be processed.
Upon selecting the folder, it will then start processing all the files
in the folder one by one. The process can be as simple as opening the
file and copy the first line etc etc.

Challenge # 2, if it allows Control-Clicking the files selectively
in that folder and then process the selected ones it would be even



No Answers Found. Be the First, To Post Answer.

Didn't find what you were looking for? Find more on Process files in a directory Or get search suggestion and latest updates.