Select tab to import from excel spreadsheet in Macro

  • Thread starter Thread starter KT
  • Start date Start date
K

KT

I have one excel file that contains multiple tabs. Is it possible to
select a specific tab to import in a Macro? I have static labels on
these tabs that can be referenced. If so, which function would that
be?

Your help is appreciated!

Kanley
 
Just to clarify, I just need to import one tab at a time, but when i
specify the worksheet name in the range field as WORKSHEET!, it
wouldn't take it.

Please help!
 

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

Import Many Tabs from Many Spreadsheets 1
Import multiple Excel tabs into access 4
Ribbon Customization - Export to Excel button 1
Excel Transfer of customized excel tabs with UI Editor but VBA code not working 0
Access to Excel 2
Refresh and run Excel macro 7
Customize Ribbon - idMso "ExportExcel" not working 3
Excel Data Transfer Issue (strange situation) 1

Back
Top