| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How many queries are there in my entire Excel workbook?
One way for all names
on a new sheetinsertnamepastelist or Sub QueryTableList() Dim q As QueryTable For Each sh In Worksheets i = 3 For Each q In sh.QueryTables 'MsgBox q.Name Cells(i, 1) = q.Name i = i + 1 Next q Next sh End Sub -- Don Guillett SalesAid Software "sjp209" wrote in message ... Is there a way to list ALL existing queries within an Excel workbook? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| enable automatic refresh | Excel Worksheet Functions | |||
| Is there a way to convert an entire Excel workbook to a pdf file? | Excel Discussion (Misc queries) | |||
| how do I change an excel template into a "workbook" | Excel Discussion (Misc queries) | |||
| Why does Excel 2003 freeze when saving a workbook that has importe | Excel Worksheet Functions | |||
| print entire workbook default | Excel Discussion (Misc queries) | |||
Hybrid Mode
