List Worksheet Names in a Dialog

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

coreygallon@gmail.com - 12 Sep 2007 20:55 GMT

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 to this Message

- - 12 Sep 2007 21:19 GMT

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.

> Hello,
>
[quoted text clipped - 3 lines]
>
> Thanks in advance for your help!

Reply to this Message