Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do you list all the workbooks you have opened and the sheets in each workbook?
How do you display a list of open workbooks and each sheet name in that
workbook?? Thanks wendy |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do you list all the workbooks you have opened and the sheets in each workbook?
Wendy,
Try this Dim i As Long Dim wb As Workbook Dim ws As Worksheet i = 1 For Each wb In Workbooks ActiveSheet.Cells(i, 1) = wb.Name i = i + 1 For Each ws In wb.Worksheets ActiveSheet.Cells(i, 2) = ws.Name i = i + 1 Next ws Next wb -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Wendy" wrote in message ... How do you display a list of open workbooks and each sheet name in that workbook?? Thanks wendy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
History of Workbooks opened | Excel Worksheet Functions | |||
list sheets in workbook | Excel Discussion (Misc queries) | |||
Merging workbooks into different sheets in a different workbook | Excel Discussion (Misc queries) | |||
List all sheets present in Workbook | Excel Worksheet Functions | |||
list of opened workbooks and selection | Excel Programming |