List Worksheet Names in a Dialog

  • Thread starter Thread starter coreygallon
  • Start date Start date
C

coreygallon

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!
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA 0
Select one or more worksheets from a listbox 4
VBA insert column with two workbooks open 1
Macro to launch the Activate dialog box? 2
Open Specific Worksheet Using Button Form Control in Excel 0
what is the way to select ASCII file and import it into excel sheet? 2
VBA - retrieve data on last create named range from previous inserted named range 0
Add-in WITH worksheets?? 1

Back
Top