Copy sheet1.range("A3:G5000") from an open file

  • Thread starter Thread starter Denys
  • Start date Start date
D

Denys

Good morning everyone,

Is there a way I can copy the above mentioned range from a file
already opened by a user and therefore marked as read-only to another
file named Recap for example?

Thank you for your time

Denys
 
ActiveWorkbook.Sheets("Sheet1").Range("A3:G5000").Copy _
Workbooks("Recap.xls").Worksheets("Sheet1").Range("A1")

Assuming the file opened by the user is the active workbook.

Tim
 
You must log in or register to reply here.

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

Convert A1 value to a sheet name and copy to it 2
[Q] How to create new worksheets based on an array (via named range) 4
Copying cells and formula from closed workbook to all sheets in open workbook 0
Copy range from Sheet1 into empty range in Sheet2 1
Open four Wbooks, copy four columns from each to Master Wbook 16
Excel VBA help: Text file formatting 19
Copy Range of data using VBA 0
Code with hidden flaw ERROR 400 13

Back
Top