| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Performing code without opening the Workbook
The below working code opens the workbook and pastes cells as links from
another workbook. How can I make the below operation work without having to actually open the 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I stop blank workbook from opening when opening an existing | Excel Discussion (Misc queries) | |||
| Code for opening a workbook at a specific time!?! | Excel Discussion (Misc queries) | |||
| How to make the opening of a workbook conditional upon the opening of another workbook | Excel Programming | |||
| How to make opening of workbook conditional of opening of another workbook | Excel Programming | |||
| Code for Opening a Closed Workbook | Excel Programming | |||
Threaded Mode
