| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy sheet1.range("A3:G5000") from an open file
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy sheet1.range("A3:G5000") from an open file
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 "Denys" wrote in message ups.com... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Unable to open a 82 KB XLSM file due to "Too many different cellformats" & "Converter failed to open the file." errors. | Excel Discussion (Misc queries) | |||
| Unable to open a 82 KB XLSM file due to "Too many different cellformats" & "Converter failed to open the file." errors. | Setting up and Configuration of Excel | |||
| if any range on sheet2 change put "a" in sheet1 cell a111 | Excel Programming | |||
| use variable in Workbooks("book1").Worksheets("sheet1").Range("a1" | Excel Programming | |||
| Problem- Recording macros for "file save" and "File open" | Excel Programming | |||
![Denys[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
