Select tab to import from excel spreadsheet in Macro

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
 
K

KT

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

Access to Excel 2
Access 2007 Excel Import Error 1
Refresh and run Excel macro 7
Import Excel Spreadsheet 1
How to cause a spreadsheet (Excel) to run from an Access Macro 4
Excel Data Transfer Issue (strange situation) 1
Import Many Tabs from Many Spreadsheets 1
Macro 1

Top