ExcelBanter - Query SELECT

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Query SELECT (https://www.excelbanter.com/excel-programming/435422-query-select.html)

BlackSun

Query SELECT

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

Bob Bridges[_2_]

Query SELECT

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?

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

All times are GMT +1. The time now is 10:36 AM.