View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
joel joel is offline
external usenet poster
 
Posts: 9,101
Default Marco to process data in many files

Here is code that I posted earlier today. It move files from one directory
to another. It only need a small modification to open the file using

workbooks.open filename:=

instead of the move instruction.

"Nils Titley" wrote:

I have a macro that process a existing excel file but now I need it to
process many files in a specific folder. I have open and closed files and
read and written data in C but I need to help getting started on this. Could
some one give me some starting code or point me in a good direction to find
an example.

Thanks