| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Executing code with opening target workbook
The below working code copys cells from an open workbook and then opens the
target workbook and pastes the copied cells as links from the other workbook. How can I make the below operation work without having to actually open the target workbook located in "Workbooks.Open Worksheets(4).Range("A6").Value" Workbooks.Open Worksheets(4).Range("A6").Value Range("A1").Select ActiveSheet.Paste Link:=True Thank you Todd Huttenstine |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Executing code with opening target workbook
don't believe you can.
-- Regards, Tom Ogilvy Todd Huttenstine wrote in message ... The below working code copys cells from an open workbook and then opens the target workbook and pastes the copied cells as links from the other workbook. How can I make the below operation work without having to actually open the target workbook located in "Workbooks.Open Worksheets(4).Range("A6").Value" Workbooks.Open Worksheets(4).Range("A6").Value Range("A1").Select ActiveSheet.Paste Link:=True Thank you Todd Huttenstine |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Code for opening a workbook at a specific time!?! | Excel Discussion (Misc queries) | |||
| Executing code with opening target workbook | Excel Programming | |||
| Performing code without opening the Workbook | Excel Programming | |||
| Code for Opening a Closed Workbook | Excel Programming | |||
| Code Changes Not Executing | Excel Programming | |||
![Todd Huttenstine[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
