Sample Excel VBA Program

[mmignot]

Does anyone know where I can find a sample Excel VBA macro that will read one or more excel files from a specific folder location, retrieve data from certain cells of each excel file, and write the data one row at a time to a new excel file?

Many thanks
MM

 

[SkipVought]

Really doubt that someone has a procedure like this in their hip pocket.

You are more likely to get some specific help in forum707, however, than in an Access forum.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]