| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy sheet from closed workbook
I am trying to figure out a way that a sheet can be copied from a
closed workbook into an open workbook. The sheet will have a unique name which will not be a duplicate to any of the sheets in the currently open book. I can't seem to find anything on this. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy sheet from closed workbook
Maybe this:
http://www.rondebruin.nl/ado.htm Or, this: http://www.rondebruin.nl/copy7.htm HTH, Ryan-- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. " wrote: I am trying to figure out a way that a sheet can be copied from a closed workbook into an open workbook. The sheet will have a unique name which will not be a duplicate to any of the sheets in the currently open book. I can't seem to find anything on this. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy sheet from closed workbook
thanks that was helpful
On Oct 1, 4:43*pm, ryguy7272 wrote: Maybe this:http://www.rondebruin.nl/ado.htm Or, this:http://www.rondebruin.nl/copy7.htm HTH, Ryan-- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''.. " wrote: I am trying to figure out a way that a sheet can be copied from a closed workbook into an open workbook. The sheet will have a unique name which will not be a duplicate to any of the sheets in the currently open book. I can't seem to find anything on this.- Hide quoted text - - Show quoted text - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help...Code to copy sheet from closed workbook | Excel Discussion (Misc queries) | |||
| copy from closed workbook again! ;( | Excel Programming | |||
| copy data from a closed workbook | 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 | |||
Linear Mode
