| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
multiple workbooks
How do I perform the same group of keystrokes to multiple workbooks.
-- Libby |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
multiple workbooks
You don't. While it is possible to group multiple sheets within a workbook to
perform actions on, it is not possible to group multiple workbooks for the same purpose (To the best of my knowledge)... -- HTH... Jim Thomlinson "Libby" wrote: How do I perform the same group of keystrokes to multiple workbooks. -- Libby |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
multiple workbooks
can I open the multiple workbooks and perform a function on all of them
-- Libby "Jim Thomlinson" wrote: You don't. While it is possible to group multiple sheets within a workbook to perform actions on, it is not possible to group multiple workbooks for the same purpose (To the best of my knowledge)... -- HTH... Jim Thomlinson "Libby" wrote: How do I perform the same group of keystrokes to multiple workbooks. -- Libby |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
multiple workbooks
Nope... You can only deal with 1 workbook at a time.
-- HTH... Jim Thomlinson "Libby" wrote: can I open the multiple workbooks and perform a function on all of them -- Libby "Jim Thomlinson" wrote: You don't. While it is possible to group multiple sheets within a workbook to perform actions on, it is not possible to group multiple workbooks for the same purpose (To the best of my knowledge)... -- HTH... Jim Thomlinson "Libby" wrote: How do I perform the same group of keystrokes to multiple workbooks. -- Libby |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
multiple workbooks
"Jim Thomlinson" wrote...
Nope... You can only deal with 1 workbook at a time. .... But you could apply the same operations to each file in sequence. For Each wb In Workbooks 'do whatever with wb Next s |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Updating Workbooks from multiple links Workbooks | Excel Worksheet Functions | |||
| macro: copy multiple workbooks to multiple tabs in single book | Excel Programming | |||
| Combine multiple workbooks into 1 workbook w/ multiple worksheets | Excel Discussion (Misc queries) | |||
| Combine multiple workbooks into 1 workbook w/ multiple worksheets | Excel Discussion (Misc queries) | |||
| adding certain cells in multiple worksheets in multiple workbooks | Excel Worksheet Functions | |||
Hybrid Mode
