Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
List Worksheet Names in a Dialog
Hello,
I am interested in creating a list of the names of the worksheets in a workbook which has been selected using the Application.GetOpenFilename dialog. How would I go about doing this? Thanks in advance for your help! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
List Worksheet Names in a Dialog
Depends on how complicated you want to get it. You can get the sheet names
from closed workbooks using ADOX, or can open each one and use simple VBA to return each sheet. wrote in message oups.com... Hello, I am interested in creating a list of the names of the worksheets in a workbook which has been selected using the Application.GetOpenFilename dialog. How would I go about doing this? Thanks in advance for your help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MAKE A LIST OF NAMES FROM REPEATED NAMES IN THE SAME WORKSHEET | Excel Discussion (Misc queries) | |||
Trying to list tab/worksheet names in a summary worksheet | Excel Discussion (Misc queries) | |||
Created list of worksheet names but need list to be hyperlinked to | Excel Programming | |||
List worksheet names | Excel Programming | |||
names.add does not list those names in the "Go to" dialog box | Excel Programming |