Marco to process data in many files

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Nils Titley - 17 Mar 2008 18:31 GMT

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

Reply to this Message

Joel - 17 Mar 2008 19:40 GMT

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.

> 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
[quoted text clipped - 3 lines]
>
> Thanks

Reply to this Message

Dave Peterson - 17 Mar 2008 19:40 GMT

Ron de Bruin has tons of sample code:
http://www.rondebruin.nl/copy3.htm
http://www.rondebruin.nl/fso.htm

> 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
[quoted text clipped - 3 lines]
>
> Thanks

Signature

Dave Peterson

Reply to this Message