| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy or replace sheet1 from a closed workbook
I have a workbook that fires macros when opened so users only have access
to a form to add and amend data - this workbook holds data I need in the workbook mentioned below. When the second workbook opens, it shoud retrieve all data in Sheet1 in the first workbook (or simply delete current Sheet1 and replace with a copy). Does anyone have a simple method? -- Steve |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Replace data into closed workbook | Excel Discussion (Misc queries) | |||
| copy from closed workbook again! ;( | Excel Programming | |||
| Possible to copy sheets into another (closed!) workbook? | Excel Discussion (Misc queries) | |||
| copy worksheet from closed workbook to active workbook using vba | Excel Worksheet Functions | |||
| copy sheet1 from all open workbooks to one workbook | Excel Programming | |||
Threaded Mode
