Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Marco to process data in many files
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Marco to process data in many files
Ron de Bruin has tons of sample code:
http://www.rondebruin.nl/copy3.htm http://www.rondebruin.nl/fso.htm 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to process multiple Excel Files | Excel Programming | |||
Use Custom Document Property to identify xls files not yet process | Excel Programming | |||
Customising Application.Filesearch to process textpad kind of files | Excel Programming | |||
How to count process running time ( process not finished) | Excel Programming | |||
Process excel files, suppress alerts | Excel Programming |