Query SELECT

  • Thread starter Thread starter BlackSun
  • Start date Start date
B

BlackSun

Hi,
Usually I use this statement: "SELECT * FROM [Sheet1$]" but if I don't
know the name of the sheet... how can I do??

Thank you in advance

Cheers,
BlackSun
 
If YOU don't know the name of the sheet, how will Excel? I mean, if it
doesn't know which sheet to do the SELECT from, how will it find the data?
 

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

Open file and set numbers of decimal points 5
Disable formula Bar in Option Menu 3
SQLCompact 2
Delete Rows of a Dataset 1
Work with 'n' decimal 6
Excel VBA to move cells to sheet2 based on selection in sheet1 0
Create Excel 2007 files 3
Reference to a DLL on the network 2

Back
Top