List Sheet Names of Selected Excel File

Hello community,

I currently have a macro that allows users to add hyperlinks to a selected file. I've been searching and I can't find a clear way to have a msgbox, or other displays to show the user the sheet names in the selected workbook after it is selected. If anyone has any answers, or a place to find an answer I would greatly appreciate it.

Please Login or Register  to view this content.

So far I have been trying to explore using methods that do not involve opening the workbook first to count the number of worksheets/list worksheet names. I know it is possible with workbook.open (StrPath), however I would just like a list of the sheet names for the user to select to add to the hyperlink (ie hyperlinks.add subaddress:= ________ )

Any information is appreciated. Thanks community!

I appreciate the quick reply! However, I don't need the sheet names of the current open/running excel sheet. I need the sheet names of the selected excel sheet in the filedialogfilepicker. I don't know of a way to do this without opening the excel file and looping through them.

Also, I do not want them pasted/inserted into the working excel workbook/worksheet. I need the worksheets of the selected workbook (via Application.FileDialog(msofiledialogfilepicker)) displayed in a msgbox or some other prompt.

Thank you