Copy from closed excel file and paste to master file then loop for same siles

S

Steve B

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.
 
G

Greg Glynn

Steve,

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

Greg
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy Data from Closed File to Existing File 0
loop to copy paste 3
loop to copy paste 5
Copy and paste between sheets error 2
Copy and Paste Loop 2
Copy range from workbooks into one master sheet 3
To open an excel file. 1
Copy columns and paste with blank column between 5

Top