Get sheet name in any workbook

  • Thread starter Thread starter OffDev
  • Start date Start date
O

OffDev

Hello,

I would like to get the name of the first sheet in any workbook that an user
chooses.
Is this possible?
I've tried wb.sheets(1).name. Doesn't work.

Please assist.
Thanks
 
Here is one way right out of VBA help file.

For Each sh In Workbooks("BOOK1.XLS").Windows(1).SelectedSheets
If sh.Name = "Sheet1" Then
MsgBox "Sheet1 is selected"
Exit For
End If
Next


You can also try: ActiveSheet.Name
 

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

Copy a sheet from one workbook to another 1
Macro for all Excel Workbooks to print to PDF 2
Help in connecting to MS Access 1
How to change a sheet name without opening the workbook 3
Copy Two Visible Ranges (From Two Sheets) To A New Workbook (AlsoWith Two Sheets) 3
Autofilter on Multiple Worksheets 5
Create New WB with copy of Sheets 1 & 2 when sheets count reaches 100 5
Refer to a lone sheet 5

Back
Top