I am trying to set up a macro to copy a range from a closed workbook
into an active workbook.

I have been able to copy and paste the information while keeping the
document closed, but I need a few other issues addressed as well.

1) I cannot make change the copy paste into a copy paste special...
value, add.

2) Also, I need the "add" feature because I want to create a loop
that pulls the same range from the same sheet in duplicate workbooks.
The only difference is that the workbooks are named in sequential
order, for example: 1.xls, 2.xls, 3.xls, etc... Can I reference the
1,2,3...?

Is there a was to create a loop that will follow these rules? The
excel files would all be in the same file ie C:\data.

Steve,

Are you making the copy with a direct reference into the closed
workbook?

Greg

Look for examples on my site Steve
http://www.rondebruin.nl/copy3.htm

Maybe you can try the ADO example ?


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Steve B" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
>
> I am trying to set up a macro to copy a range from a closed workbook
> into an active workbook.
>
> I have been able to copy and paste the information while keeping the
> document closed, but I need a few other issues addressed as well.
>
> 1) I cannot make change the copy paste into a copy paste special...
> value, add.
>
> 2) Also, I need the "add" feature because I want to create a loop
> that pulls the same range from the same sheet in duplicate workbooks.
> The only difference is that the workbooks are named in sequential
> order, for example: 1.xls, 2.xls, 3.xls, etc... Can I reference the
> 1,2,3...?
>
> Is there a was to create a loop that will follow these rules? The
> excel files would all be in the same file ie C:\data.
>